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 |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|