Thread: Lining up data from concatenation
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc
Herbert Seidenberg
 
Posts: n/a
Default Lining up data from concatenation
Not a bad thought.
Just do the formatting inside the formula.
=CONCATENATE(TEXT(A1,"0000")," ",B1)

Reply With QuoteReply With Quote