View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Saz Saz is offline
external usenet poster
 
Posts: 15
Default Cell Formating (concatenate two cells)

Hi All,

I am trying to concatenate two cells and it displays like this on
column C, when I use this formula: =A2&"(five spaces)"&B2

John Doe 60
Mike Smith 70
Sarah Anderson 80
George Washington 65

How can I align my Column C like this

John Doe 60
Mike Smith 70
Sarah Anderson 80
George Washington 65

I am trying to kind of justify column C if that is possible.

Thank you,
Saz