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

Posted on 2015-01-10
Medium Priority
Last Modified: 2015-02-07
Is there an easy way to fill a series of filenames in Excel? I'm using Excel 2013.

For example:



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

Question by:MrComputerIT
LVL 43

Accepted Solution

Saqib Husain, Syed earned 2000 total points
ID: 40542467
You can try this formula in row 1 and copied down


Expert Comment

by:Let's Go
ID: 40543463
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:
LVL 52

Expert Comment

by:Martin Liss
ID: 40595420
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question