If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. ? |
#3
|
|||
|
|||
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 ©¿©¬ . |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 ©¿©¬ . |
Thread Tools | |
Display Modes | |
|
|