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

Cell Formating (concatenate two cells)
 

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

Cell Formating (concatenate two cells)
 

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

Cell Formating (concatenate two cells)
 

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

Cell Formating (concatenate two cells)
 

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