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 |
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 |
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 |
All times are GMT +1. The time now is 04:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com