Home |
Search |
Today's Posts |
#1
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
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
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
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
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
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
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
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
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
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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
rename
On Wed, 24 Mar 2010 10:21:12 -0500, Dave Peterson
wrote: Explain each step you've tried -- in great detail. Did you reformat the cell to General? yes Did you reenter the formula? yes Did you copy the formula down using the autofill handle? yes 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? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
rename
Did you check to see if you were looking at formulas?
If that's a yes, then I don't have any other suggestions. Martin, ©¿©¬, @nohere.net wrote: On Wed, 24 Mar 2010 10:21:12 -0500, Dave Peterson wrote: Explain each step you've tried -- in great detail. Did you reformat the cell to General? yes Did you reenter the formula? yes Did you copy the formula down using the autofill handle? yes 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 |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
rename
On Wed, 24 Mar 2010 16:45:51 -0500, Dave Peterson
wrote: Did you check to see if you were looking at formulas? If that's a yes, then I don't have any other suggestions. Dave, I have just now entered =d2 & " " & c2 and it worked ?? ??"" I have no idea why Thank you for all your help -- Regards Martin ©¿©¬ Martin, ©¿©¬, @nohere.net wrote: On Wed, 24 Mar 2010 10:21:12 -0500, Dave Peterson wrote: Explain each step you've tried -- in great detail. Did you reformat the cell to General? yes Did you reenter the formula? yes Did you copy the formula down using the autofill handle? yes 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? |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
rename
On Wed, 24 Mar 2010 16:45:51 -0500, Dave Peterson
wrote: Did you check to see if you were looking at formulas? If that's a yes, then I don't have any other suggestions. Thank you Dave for your help -- Regards Martin ©¿©¬ Martin, ©¿©¬, @nohere.net wrote: On Wed, 24 Mar 2010 10:21:12 -0500, Dave Peterson wrote: Explain each step you've tried -- in great detail. Did you reformat the cell to General? yes Did you reenter the formula? yes Did you copy the formula down using the autofill handle? yes 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? |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
rename
If you don't change the numberformat first, then you'll have trouble.
I'm guessing that you did the steps in the incorrect order. Martin, ©¿©¬, @nohere.net wrote: On Wed, 24 Mar 2010 16:45:51 -0500, Dave Peterson wrote: Did you check to see if you were looking at formulas? If that's a yes, then I don't have any other suggestions. Dave, I have just now entered =d2 & " " & c2 and it worked ?? ??"" I have no idea why Thank you for all your help -- Regards Martin ©¿©¬ Martin, ©¿©¬, @nohere.net wrote: On Wed, 24 Mar 2010 10:21:12 -0500, Dave Peterson wrote: Explain each step you've tried -- in great detail. Did you reformat the cell to General? yes Did you reenter the formula? yes Did you copy the formula down using the autofill handle? yes 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
Rename a range . | Excel Discussion (Misc queries) | |||
Save and rename | Excel Discussion (Misc queries) | |||
Help to rename files | Excel Worksheet Functions | |||
Rename Add-Ins | Excel Discussion (Misc queries) |