Cell Formating (concatenate two cells)

[Saz]

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

 

[Saz]

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

 

[Lars-Åke Aspelin]

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

 

[Peo Sjoblom]

The left part can be done without entering 25 spaces

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



--


Regards,


Peo Sjoblom

 

[John C]

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).