Delemited string

[Pierre Leclerc]

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
(e-mail address removed)

 

[Frank Kabel]

Hi
to you mean something like
=A1 & REPT(" ",100-LEN(A1))

 

[Ashish Mathur]

Hi,

You can play around with the custom number format. There is enough help
available on this on the Knowledge base.

Regards,

Ashish Mathur