CONCATENATE error?
 

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
©¿©¬

CONCATENATE error?
 

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

CONCATENATE error?
 

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
©¿©¬

.

CONCATENATE error?
 

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
...
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
©¿©¬

CONCATENATE error?
 

=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
©¿©¬

.