The original string lenght may vary from 1 to 30.

Using a formula...

A1 = some string

B1 = formula:

=A1&REPT(" ",30-LEN(A1))

--
Biff
Microsoft Excel MVP


"JABAgdl" wrote in message
...
eHello:

I need to always have 30 char in a given cell, if the original string is
less than 30 chars, lets say 23 then I need to fill in at the right of the
string with 7 blank spaces. The original string lenght may vary from 1 to
30.
Is there a formula or VBA code to do this?
Any and all help would be highly appreciated!

PLK