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