MrComputerIT
asked on
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!!
For example:
Filename1.ext
Filename2.ext
Filename3.ext..
etc..
I have hundreds and I was looking for a shortcut. :)
Thanks!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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"