Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Delemited string
Hi all
I remember using an Excel function that allowd me to transform a string into a delemited string adding spaces or zeros to the right or the left. What is this function, I can't retrace it. Thanks in advance Pierre Leclerc http://www.excel-vba.com |
#2
|
|||
|
|||
Hi
to you mean something like =A1 & REPT(" ",100-LEN(A1)) -- Regards Frank Kabel Frankfurt, Germany "Pierre Leclerc" schrieb im Newsbeitrag ... Hi all I remember using an Excel function that allowd me to transform a string into a delemited string adding spaces or zeros to the right or the left. What is this function, I can't retrace it. Thanks in advance Pierre Leclerc http://www.excel-vba.com |
#3
|
|||
|
|||
Hi,
You can play around with the custom number format. There is enough help available on this on the Knowledge base. Regards, Ashish Mathur "Pierre Leclerc" wrote: Hi all I remember using an Excel function that allowd me to transform a string into a delemited string adding spaces or zeros to the right or the left. What is this function, I can't retrace it. Thanks in advance Pierre Leclerc http://www.excel-vba.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find nth instance of a character in a string | Excel Discussion (Misc queries) | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
how to count the nr of occurrences of a text string in a cell rang | Excel Worksheet Functions | |||
Add a string to a cell | Excel Worksheet Functions |