| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Padding and Concatenate
Okay I have a collumn of formulas that generate numerical codes.
Because they're codes I need them to retain the 000 padding before them. I do this by using the custom padding. so excel displays the collumn like... 0000001 0000002 0000003 Now... I need to concatenate these numerical values to the end of a text code. so I'm adding say, "code" to the begining of each. what I want looks like code.0000001 code.0000002 code.0000003 but when I try to do it, I loose the padding, resulting in code.1 code.2 code.3 any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Padding and Concatenate
If the numbers are in column A, consider:
="code."&Text(A1,"0000000") -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Static" wrote: Okay I have a collumn of formulas that generate numerical codes. Because they're codes I need them to retain the 000 padding before them. I do this by using the custom padding. so excel displays the collumn like... 0000001 0000002 0000003 Now... I need to concatenate these numerical values to the end of a text code. so I'm adding say, "code" to the begining of each. what I want looks like code.0000001 code.0000002 code.0000003 but when I try to do it, I loose the padding, resulting in code.1 code.2 code.3 any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Padding and Concatenate
ah yes, thank you. Thats exactly what I needed.
"Wigi" wrote: If the numbers are in column A, consider: ="code."&Text(A1,"0000000") -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Static" wrote: Okay I have a collumn of formulas that generate numerical codes. Because they're codes I need them to retain the 000 padding before them. I do this by using the custom padding. so excel displays the collumn like... 0000001 0000002 0000003 Now... I need to concatenate these numerical values to the end of a text code. so I'm adding say, "code" to the begining of each. what I want looks like code.0000001 code.0000002 code.0000003 but when I try to do it, I loose the padding, resulting in code.1 code.2 code.3 any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Padding with leading zeros | Excel Discussion (Misc queries) | |||
| Cell margins/padding | Excel Discussion (Misc queries) | |||
| padding ? | Excel Discussion (Misc queries) | |||
| Change the cell padding? | Excel Worksheet Functions | |||
Linear Mode
