If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Continuing a list with text and numbers
I want to fill a column with image ID numbers followed by a suffix ie, "001.jpg" without the speech marks, and have Excel continue the list down the column, but I can't get the ".jpg" part to copy, only the numbers, so at present I am filling in each cell which takes forever!
Is there an easy to do this? The actual total of numbers will vary each time - it is for a photography web-site, but each one needs the identifier after the number without a space. Can someone suggest a step-by-step method of doing this if it is possible and is there a way to save the "formula" for further use? I hope someone can help as this is driving me mad! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
adding values from another worksheet by matching criteria | Frank Kabel | Worksheet Functions | 2 | March 16th, 2004 03:15 PM |
Numbers formatted as text - os so you'd think | Stacy | Worksheet Functions | 3 | February 18th, 2004 12:30 PM |
convert numbers to text | bMunny | Worksheet Functions | 6 | December 5th, 2003 07:50 PM |