Thread: combing cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default combing cells

yes you can. length has nothing to do with it. and it will
cocatenate in the order you state. spaces can be added
=CONCATENATE(A2," ",B2)

-----Original Message-----
I am trying to combine 2 cells with one of the cells
being right justified. Can't use the concatenate command
because my first cell may not be the same length
(characters) and the second cell has to be at the end.
Spacing will become a user problem and time consuming.
Any help would be greatly appreciated.
.