View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
briancrosier briancrosier is offline
external usenet poster
 
Posts: 4
Default Text with repeating trailing spaces

I need to create a text string from several different values that I have
calculated, however I need the resulting string to be fixed width (ie. the
first entry needs to be inserted followed by spaces to total 30 characters).
I know it can be done as I did this previously, but forget how. Can anybody
help?