|
| 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 23rd, 2010, 04:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
March 23rd, 2010, 04:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 23rd, 2010, 05:02 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 24th, 2010, 11:57 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 24th, 2010, 12:04 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 24th, 2010, 12:05 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 24th, 2010, 12:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 24th, 2010, 02:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 24th, 2010, 02:59 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
March 24th, 2010, 03:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
