If you want some flexibility, you could use the following array** formula.
This will mean there will always be at least 5 spaces between the 2 sets of
data, no matter how long the data in column A is, or how long the data in
column B is.

=A2&REPT(" ",MAX(LEN($A$2:$A$6))-LEN(A2)+5+MAX(LEN($B$2:$B$6))-LEN(B2))&B2

**When entering an array formula, press CTRL+SHIFT+ENTER to commit the
formula. After you do, brackets { } should appear around the formula. Copy
down and expand data range as needed (currently only rows 2 through 6 are
looked at).


--
John C


"Saz" wrote:

On Jul 28, 4:02 pm, 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