View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JABAgdl JABAgdl is offline
external usenet poster
 
Posts: 4
Default cell lenght MUST be always 30

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