| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill numbers starting with zero | Excel Discussion (Misc queries) | |||
| How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) | |||
| I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
| How do I get auto fill to do decending numbers in a column? | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions | |||
Linear Mode
