View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Brown
 
Posts: n/a
Default How do I add leading spaces to a value?

I have a list of values that vary in length, but I need to convert all of
them to 10 characters with spaces, not 0's as prefixes.

I have been able to use the text command to add 0's, but unable to add spaces.

Thanks in advance for any help!

-Chris