Thread: Lining up data from concatenation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
mrice
 
Posts: n/a
Default Lining up data from concatenation

Try

=A1 & LEFT(" ",4-LEN(A1)) & B1

You will need to use a fixed width font like courier new to get the
effect to work properly.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=547979

Reply With QuoteReply With Quote