| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating sequential text string of fixed length
Hi - I need a formula that will generate text strings in rows like
row 1 0001 row 2 0002 row 3 0003 .. .. .. row 9999 9999 I want the leading zeros and I can't figure out what value to use in the Text formula to get that to work. Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to column fixed length | Excel Discussion (Misc queries) | |||
| Fixed Length, Text Formatted | Excel Discussion (Misc queries) | |||
| creating numbers to a fixed length string... | Excel Worksheet Functions | |||
| Fixed length text file | Excel Discussion (Misc queries) | |||
| fixed string length,even other record is copied | Excel Discussion (Misc queries) | |||
Threaded Mode
