Add the same characters to 4000 strings in Excel
Posted on 2011-02-23
This is probably a simple question to someone who uses Excel a lot.
Here's the situation...
I'm using Excel2010. I have a spreadsheet with about 4000 rows of serial numbers, short descriptions, etc. One of the columns is image names but without the ".jpg" file extension. I need to add ".jpg" to all 4000 image names in that column. How is this done besides typing it in one image at a time?
If I use Find and Replace then I'll have to do it 36 times to match up with the image names that end in all the different alpha numeric characters. Isn't there a way to add the file extension (or any set of characters) to every string in a column?
TIA your Excel expertise