Mass change file extension in excel column

[toshacolephoto]

I have file names in a column in Excel. I have them as .jpg and I need them to all be .png to match up with a photo automation I am running. Is there any way I can mass change the file extension from .jpg to .png without messing with the file name?

[#2 · Accepted solution]

@toshacolephoto Use Find & Replace, as follows:

ctrl-H open the Find & Replace window;

type .jpg in the Find what: field;

type .png in the Replace with: field;

press Replace All.

And you're done!

Alternatively, you may look into Flash Fill. Start by entering a few corrected filenames/extensions in an adjacent column. Select the entire range you want to fill

.... and press ctrl-E.

[#3]

Thank you!! I will give that a go!