Forum Discussion
Mass change file extension in excel column
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.
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.
