Auto fill numbers and text

  • Thread starter Thread starter karchivese
  • Start date Start date
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!
 
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)
 
Back
Top