View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
 
Posts: 695
Default Cleanly Trimming text...

if i got u right, try :

=A2&" "&B2&" "&C2&" "&D2&" "&2&.....