Is it possible to fill a series that is a list of filenames in Excel that have numbers in them?

Is there an easy way to fill a series of filenames in Excel? I'm using Excel 2013.

For example:

Filename1.ext
Filename2.ext
Filename3.ext..

etc..

I have hundreds and I was looking for a shortcut. :)

Thanks!!
MrComputerITAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
You can try this formula in row 1 and copied down

="Filename"&ROW()&".ext"
0
 
Let's GoCommented:
Or you could start:
A1: "Filename1"
A2: "Filename2"
A3: "Filename3"

Then use the normal Excel Autofill by dragging down.

You would then use the following formula in column B:
=A1&".ext"
0
 
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.