Forum Discussion
toshacolephoto
May 23, 2022Copper Contributor
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...
- May 23, 2022
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.
Riny_van_Eekelen
May 23, 2022Platinum Contributor
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.
- toshacolephotoMay 23, 2022Copper ContributorThank you!! I will give that a go!