Forum Discussion
Mass change file extension in excel column
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?
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.
2 Replies
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.
- Thank you!! I will give that a go!
