From: Martin ���� on 26 Mar 2010 13:40 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 ����
From: Chip Pearson on 26 Mar 2010 14:31 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. ?
From: מיכאל (מיקי) אבידן on 26 Mar 2010 14:35 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 > ©¿©¬ > > . >
From: T. Valko on 26 Mar 2010 14:36 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 news:ifnpq5doifkjn3th7srg3cr9v7uah0c8j0(a)4ax.com... > 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 > ���� >
From: SueW on 26 Mar 2010 15:10 =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 > ©¿©¬ > > . >

Pages: 1 Prev: numbering items in a cell Next: How do I stop excel from automatically highlighting cells? 