Home

Adding an extension to series of file names

%3CLINGO-SUB%20id%3D%22lingo-sub-927887%22%20slang%3D%22en-US%22%3EAdding%20an%20extension%20to%20series%20of%20file%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927887%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20add%20an%20extension%20such%20as%20.jpg%20or%20.tif%20to%20each%20of%20the%20file%20names%20in%20a%20series%20of%20cells%20in%20Excel%20without%20having%20to%20click%20on%20each%20cell%20and%20paste%20the%20extension%20in%20each%20of%20the%20cells.%20It%20gets%20very%20tedious%20200-400%20times.%20Excel%20easily%20builds%20the%20sequence%20of%20numbers%20by%20dragging%20the%20corner%20of%20a%20cell%20sequence.%20But%20I%20can't%20find%20a%20way%20to%20add%20the%20same%20set%20of%20characters%20to%20the%20end%20of%20each%20file%20name%20in%20a%20long%20sequence.%20Is%20it%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-927887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-928048%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20an%20extension%20to%20series%20of%20file%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-928048%22%20slang%3D%22en-US%22%3EAs%20a%20short%20term%20fix%20(assuming%20this%20isn't%20something%20you%20have%20to%20do%20every%20day%2C%20in%20which%20case%20a%20macro%20might%20be%20needed%20to%20automate%20what%20I'm%20going%20to%20tell%20you...)%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20the%20column%20next%20to%20the%20cells%20in%20question%2C%20enter%20this%20formula%3CBR%20%2F%3E%3DCONCATENATE(A1%2C%22.jpg%22)%20OR%20%3DA1%26amp%3B%22.jpg%22%3CBR%20%2F%3EIn%20place%20of%20A1%20in%20that%20example%2C%20just%20place%20whatever%20your%20top%20cell%20reference%20is.%3CBR%20%2F%3ECopy%20this%20formula%20down%20next%20to%20the%20whole%20column.%3CBR%20%2F%3EThen%20highlight%20your%20new%20%22complete%22%20names.%3CBR%20%2F%3ECopy%3CBR%20%2F%3EPut%20on%20top%20of%20the%20originals%20and%20select%20%22Paste%20Special%22%20and%20select%20%22Values%22%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20you%20can%20erase%20the%20formulas%3B%20they%20were%20just%20temporary%20to%20accomplish%20that%20change.%3C%2FLINGO-BODY%3E
MGHSJ1961
Occasional Visitor

I want to add an extension such as .jpg or .tif to each of the file names in a series of cells in Excel without having to click on each cell and paste the extension in each of the cells. It gets very tedious 200-400 times. Excel easily builds the sequence of numbers by dragging the corner of a cell sequence. But I can't find a way to add the same set of characters to the end of each file name in a long sequence. Is it possible?

1 Reply
As a short term fix (assuming this isn't something you have to do every day, in which case a macro might be needed to automate what I'm going to tell you...)

In the column next to the cells in question, enter this formula
=CONCATENATE(A1,".jpg") OR =A1&".jpg"
In place of A1 in that example, just place whatever your top cell reference is.
Copy this formula down next to the whole column.
Then highlight your new "complete" names.
Copy
Put on top of the originals and select "Paste Special" and select "Values"

Then you can erase the formulas; they were just temporary to accomplish that change.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies