The left part can be done without entering 25 spaces

=LEFT(A2&REPT(" ",25),25)



--


Regards,


Peo Sjoblom

"Lars-Åke Aspelin" wrote in message
...
On Mon, 28 Jul 2008 14:02:50 -0700 (PDT), Saz
wrote:

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


Try this formula in cell C2:

=LEFT(A2&" (25 spaces here) ",25)&RIGHT(" "&B2,5)

Hope this helps / Lars-Åke