|
| 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
March 26th, 2010, 05:40 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
March 26th, 2010, 06:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 26th, 2010, 06:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 26th, 2010, 06:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 26th, 2010, 07:10 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
