Auto fill numbers and text

K

karchivese

I need to fill out a column for file numbers that are combination text and
numbers.

The files follow the format ABRE1234.tif.

It won't let me drag and fill the series with the ".tif"

Is there a way to fill the series with the .tif, or do I always have to add
is seperately after I have filled the series in the column.

Thanks!
 
D

Dave Peterson

You could use a pair of columns.

Put ABRE1234 in column A and drag it down.

Then use =a1&".tif"

===
Or maybe you could use a formula:
="ABRE" & text(row()+1233, "0000") & ".tif"
(in A1, and then drag down)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
Auto Fill Defaults 3
Fill without formatting 1
Fill repeating Numbers 8
Excel Macro to automatically go to the right of the last colored cell 0
Auto update row numbers after inserting new row 4
Calculate (Auto Fill) cells with numbers and text. 3
Setting Fill Handle Defaults 3

Top