| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating sequential text string of fixed length
Try:
=Text(row(),"0000") That didn't work for me, but this did Put Row 1 0001 in Col B Put 0001 in Col C Put function =RIGHT(B2,4) in Col D Put function =CONCATENATE(C2," ",D2) in Col E Copy down 9999 rows Use Copy & Paste Special/Values to put Col E info into an empty column and delete Cols B thru E. It's not very elegant, but it does the job quick and EZ. good luck |
| 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
