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
|
|||
|
|||
rename
Hi
I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc in D2 I have McAllister Hay Farquhar Russell Cuthbert etc etc How do I create a list in E2 McAllister Mr & Mrs E. Hay Mrs E. etc etc? -- Martin ©¿©¬ |
#2
|
|||
|
|||
rename
Assuming names are not all in C2 or D2 but rather in columns C and D
In E2 enter =D2 & " " & C2 Copy down. If all in one cell, how are they separated? Gord Dibben MS Excel MVP On Tue, 23 Mar 2010 16:00:14 +0000, Martin ©¿©¬ @nohere.net wrote: Hi I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc in D2 I have McAllister Hay Farquhar Russell Cuthbert etc etc How do I create a list in E2 McAllister Mr & Mrs E. Hay Mrs E. etc etc? |
#3
|
|||
|
|||
rename
=CONCATENATE(D2,C2)
-- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Martin ©¿©¬ @nohere.net" wrote: Hi I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc in D2 I have McAllister Hay Farquhar Russell Cuthbert etc etc How do I create a list in E2 McAllister Mr & Mrs E. Hay Mrs E. etc etc? -- Martin ©¿©¬ . |
#4
|
|||
|
|||
rename
On Tue, 23 Mar 2010 09:27:57 -0700, Gord Dibben gorddibbATshawDOTca
wrote: Assuming names are not all in C2 or D2 but rather in columns C and D Assumption correct In E2 enter =D2 & " " & C2 Copy down. This didn't work Gord I just got =D2 & " " & C2 in every cell ? -- Martin ©¿©¬ If all in one cell, how are they separated? Gord Dibben MS Excel MVP On Tue, 23 Mar 2010 16:00:14 +0000, Martin ©¿©¬ @nohere.net wrote: Hi I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc in D2 I have McAllister Hay Farquhar Russell Cuthbert etc etc How do I create a list in E2 McAllister Mr & Mrs E. Hay Mrs E. etc etc? |
#5
|
|||
|
|||
rename
Format the cells as General (or anything but Text).
Then reenter the top formula and drag down again. Martin, ©¿©¬, @nohere.net wrote: On Tue, 23 Mar 2010 09:27:57 -0700, Gord Dibben gorddibbATshawDOTca wrote: Assuming names are not all in C2 or D2 but rather in columns C and D Assumption correct In E2 enter =D2 & " " & C2 Copy down. This didn't work Gord I just got =D2 & " " & C2 in every cell ? -- Martin ©¿©¬ If all in one cell, how are they separated? Gord Dibben MS Excel MVP On Tue, 23 Mar 2010 16:00:14 +0000, Martin ©¿©¬ @nohere.net wrote: Hi I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc in D2 I have McAllister Hay Farquhar Russell Cuthbert etc etc How do I create a list in E2 McAllister Mr & Mrs E. Hay Mrs E. etc etc? -- Dave Peterson |
#6
|
|||
|
|||
rename
On Tue, 23 Mar 2010 10:02:06 -0700, Russell Dawson
wrote: =CONCATENATE(D2,C2) Hi Russell, this works fine however, a space is needed in the formula CarrickMr & Mrs F. - should be Carrick Mr & Mrs F. How would I fix that please ? -- Martin ©¿©¬ |
#7
|
|||
|
|||
rename
On Wed, 24 Mar 2010 07:04:12 -0500, Dave Peterson
wrote: Format the cells as General (or anything but Text). Then reenter the top formula and drag down again. That didn't work either Dave My colums have a header row if that makes a difference -- Martin ©¿©¬ Martin, ©¿©¬, @nohere.net wrote: On Tue, 23 Mar 2010 09:27:57 -0700, Gord Dibben gorddibbATshawDOTca wrote: Assuming names are not all in C2 or D2 but rather in columns C and D Assumption correct In E2 enter =D2 & " " & C2 Copy down. This didn't work Gord I just got =D2 & " " & C2 in every cell ? -- Martin ©¿©¬ If all in one cell, how are they separated? Gord Dibben MS Excel MVP On Tue, 23 Mar 2010 16:00:14 +0000, Martin ©¿©¬ @nohere.net wrote: Hi I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc in D2 I have McAllister Hay Farquhar Russell Cuthbert etc etc How do I create a list in E2 McAllister Mr & Mrs E. Hay Mrs E. etc etc? |
#8
|
|||
|
|||
rename
How did it not work?
If you got the same results, then try it again. I'd guess you missed a step. Or... You may be looking at formulas. Tools|Options|view tab|uncheck formulas (in xl2003 menus) Martin, ©¿©¬, @nohere.net wrote: On Wed, 24 Mar 2010 07:04:12 -0500, Dave Peterson wrote: Format the cells as General (or anything but Text). Then reenter the top formula and drag down again. That didn't work either Dave My colums have a header row if that makes a difference -- Martin ©¿©¬ Martin, ©¿©¬, @nohere.net wrote: On Tue, 23 Mar 2010 09:27:57 -0700, Gord Dibben gorddibbATshawDOTca wrote: Assuming names are not all in C2 or D2 but rather in columns C and D Assumption correct In E2 enter =D2 & " " & C2 Copy down. This didn't work Gord I just got =D2 & " " & C2 in every cell ? -- Martin ©¿©¬ If all in one cell, how are they separated? Gord Dibben MS Excel MVP On Tue, 23 Mar 2010 16:00:14 +0000, Martin ©¿©¬ @nohere.net wrote: Hi I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc in D2 I have McAllister Hay Farquhar Russell Cuthbert etc etc How do I create a list in E2 McAllister Mr & Mrs E. Hay Mrs E. etc etc? -- Dave Peterson |
#9
|
|||
|
|||
rename
On Wed, 24 Mar 2010 09:09:59 -0500, Dave Peterson
wrote: How did it not work? If you got the same results, then try it again. I'd guess you missed a step. Or... You may be looking at formulas. Tools|Options|view tab|uncheck formulas (in xl2003 menus) Did it again, several times I still get =D2 & " " & C2 in each cell I'm using 2007 -- Martin ©¿©¬ Martin, ©¿©¬, @nohere.net wrote: On Wed, 24 Mar 2010 07:04:12 -0500, Dave Peterson wrote: Format the cells as General (or anything but Text). Then reenter the top formula and drag down again. That didn't work either Dave My colums have a header row if that makes a difference -- Martin ©¿©¬ Martin, ©¿©¬, @nohere.net wrote: On Tue, 23 Mar 2010 09:27:57 -0700, Gord Dibben gorddibbATshawDOTca wrote: Assuming names are not all in C2 or D2 but rather in columns C and D Assumption correct In E2 enter =D2 & " " & C2 Copy down. This didn't work Gord I just got =D2 & " " & C2 in every cell ? -- Martin ©¿©¬ If all in one cell, how are they separated? Gord Dibben MS Excel MVP On Tue, 23 Mar 2010 16:00:14 +0000, Martin ©¿©¬ @nohere.net wrote: Hi I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc in D2 I have McAllister Hay Farquhar Russell Cuthbert etc etc How do I create a list in E2 McAllister Mr & Mrs E. Hay Mrs E. etc etc? |
#10
|
|||
|
|||
rename
Explain each step you've tried -- in great detail.
Did you reformat the cell to General? Did you reenter the formula? Did you copy the formula down using the autofill handle? Martin, ©¿©¬, @nohere.net wrote: On Wed, 24 Mar 2010 09:09:59 -0500, Dave Peterson wrote: How did it not work? If you got the same results, then try it again. I'd guess you missed a step. Or... You may be looking at formulas. Tools|Options|view tab|uncheck formulas (in xl2003 menus) Did it again, several times I still get =D2 & " " & C2 in each cell I'm using 2007 -- Martin ©¿©¬ Martin, ©¿©¬, @nohere.net wrote: On Wed, 24 Mar 2010 07:04:12 -0500, Dave Peterson wrote: Format the cells as General (or anything but Text). Then reenter the top formula and drag down again. That didn't work either Dave My colums have a header row if that makes a difference -- Martin ©¿©¬ Martin, ©¿©¬, @nohere.net wrote: On Tue, 23 Mar 2010 09:27:57 -0700, Gord Dibben gorddibbATshawDOTca wrote: Assuming names are not all in C2 or D2 but rather in columns C and D Assumption correct In E2 enter =D2 & " " & C2 Copy down. This didn't work Gord I just got =D2 & " " & C2 in every cell ? -- Martin ©¿©¬ If all in one cell, how are they separated? Gord Dibben MS Excel MVP On Tue, 23 Mar 2010 16:00:14 +0000, Martin ©¿©¬ @nohere.net wrote: Hi I have several lists of names In C2 i have Mr & Mrs E. Mrs E. Rev. G. & Mr M. Mrs M. Mr & Mrs J. etc etc in D2 I have McAllister Hay Farquhar Russell Cuthbert etc etc How do I create a list in E2 McAllister Mr & Mrs E. Hay Mrs E. etc etc? -- Dave Peterson |
|
Thread Tools | |
Display Modes | |
|
|