cell lenght MUST be always 30
You don't say what you want if there are more than 30 characters in a cell.
Do you have to deal with that?
Or did you mean "at least" 30 characters?
Gord Dibben MS Excel MVP
On Thu, 18 Feb 2010 20:30:01 -0800, JABAgdl
wrote:
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
|