I have about 9000 cells that contain numbers. I need to add some text at the end. For example cells are like this: 10001 10002 10045.... I need to add the following (.gif at the end of each number): 10001.gif 10002.gif 10045.gif Anyone know of a way to do this in Excel or anything?
You can do this in Excel pretty quickly... Put a formula in the cell adjacent to the number you want to add '.gif' to... For example, if your number '10001' is in cell A1, in cell B1 put the following formula: =A1&".gif" Then, copy the formula down for all 9000 cells. Highlight the cells containing the formulas and do a Copy / Paste Special - Values to get rid of the formulas.