how to append text to the end of a row

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I have to batch rename a few thousand images that are named something like
1-1234-1111-1.jpg

A program I have can rename using a csv file with 2 columns
originalname;newname
1-1234-1111-1.jpg;978-1-1234-1111-1.jpg

This works awesome, however it has to include the extension because
otherwise it can't match up the files... which is good because its possible
that there could be files with the same name but different extension. I can
easily open the csv in notepad and find replace ; with .jpg; but I don't
know how to do that for the 2nd row. There is a space after the last
character but it wont let me find and replace a space with .jpg

Is there a way that I could create a 3rd column with .jpg and then merge it
with the 2nd column so they become one? I am using Excel 2002.

Any help greatly appreciated.
Thanks.
 
Bleh, never mind.
I just added a third column in excel with no values for each row so then
when I opened in notepad the 2nd column had a comma at the end and I was
able to work with that.

Thanks anyways
 
Back
Top