Home |
Search |
Today's Posts |
#1
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
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
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
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
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 ©¿©¬ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate Error | Excel Discussion (Misc queries) | |||
Concatenate error | Excel Discussion (Misc queries) | |||
concatenate expression error | Excel Worksheet Functions | |||
why do i sometimes get a "value" error when i try to concatenate? | Excel Discussion (Misc queries) | |||
Use numbers in CONCATENATE formula without getting error | Excel Worksheet Functions |