ExcelBanter - Auto fill numbers and text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Auto fill numbers and text (https://www.excelbanter.com/excel-discussion-misc-queries/174430-auto-fill-numbers-text.html)

Auto fill numbers and text

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!

Auto fill numbers and text

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)

karchivese wrote:

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!

--

Dave Peterson