Prev: numbering items in a cell
Next: How do I stop excel from automatically highlighting cells?
From: Martin ���� on 26 Mar 2010 13:40
Hi
in column C row 2 I have Mr & Mrs E.
in colum D row 2 I have McAllister
When I put the formula =CONCATENATE(D2,C2) in E2 I get
McAllisterMr & Mrs E.

How do I adjust the formula to get
McAllister Mr & Mrs E. ?
--
Martin
����

From: Chip Pearson on 26 Mar 2010 14:31
The CONCATENATE function doesn't put any separators between the values
that are concatenated. You must include it yourself. Moreover, it is
easier to just use the '&' operator than the CONCATENATE function:

=CONCATENATE(D2," ",C2)
or
=D2 & " " & C2

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Fri, 26 Mar 2010 17:40:39 +0000, Martin ���� @nohere.net wrote:

>Hi
>in column C row 2 I have Mr & Mrs E.
>in colum D row 2 I have McAllister
>When I put the formula =CONCATENATE(D2,C2) in E2 I get
>McAllisterMr & Mrs E.
>
>How do I adjust the formula to get
>McAllister Mr & Mrs E. ?
From: מיכאל (מיקי) אבידן on 26 Mar 2010 14:35
Maybe: =D2&" "&C2
Micky


"Martin ©¿©¬ @nohere.net" wrote:

> Hi
> in column C row 2 I have Mr & Mrs E.
> in colum D row 2 I have McAllister
> When I put the formula =CONCATENATE(D2,C2) in E2 I get
> McAllisterMr & Mrs E.
>
> How do I adjust the formula to get
> McAllister Mr & Mrs E. ?
> --
> Martin
> ©¿©¬
>
> .
>
From: T. Valko on 26 Mar 2010 14:36
Try it like this...

=D2&" "&C2

Which is the same as:

=CONCATENATE(D2," ",C2)

But why do all that extra typing! <g>

--
Biff
Microsoft Excel MVP


<Martin ���� @nohere.net> wrote in message
news:ifnpq5doifkjn3th7srg3cr9v7uah0c8j0(a)4ax.com...
> Hi
> in column C row 2 I have Mr & Mrs E.
> in colum D row 2 I have McAllister
> When I put the formula =CONCATENATE(D2,C2) in E2 I get
> McAllisterMr & Mrs E.
>
> How do I adjust the formula to get
> McAllister Mr & Mrs E. ?
> --
> Martin
> ����
>


From: SueW on 26 Mar 2010 15:10
=CONCATENATE(C2,D2)

"Martin ©¿©¬ @nohere.net" wrote:

> Hi
> in column C row 2 I have Mr & Mrs E.
> in colum D row 2 I have McAllister
> When I put the formula =CONCATENATE(D2,C2) in E2 I get
> McAllisterMr & Mrs E.
>
> How do I adjust the formula to get
> McAllister Mr & Mrs E. ?
> --
> Martin
> ©¿©¬
>
> .
>
 | 
Pages: 1
Prev: numbering items in a cell
Next: How do I stop excel from automatically highlighting cells?