• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 62
  • Last Modified:

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!!
0
MrComputerIT
Asked:
MrComputerIT
1 Solution
 
Saqib Husain, SyedEngineerCommented:
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 LissRetired ProgrammerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now