A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

rename



 
 
Thread Tools Display Modes
  #11  
Old March 24th, 2010, 07:01 PM posted to microsoft.public.excel.misc
Martin ©¿©¬ @nohere.net
external usenet poster
 
Posts: 241
Default 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  
Old March 24th, 2010, 10:45 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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  
Old March 26th, 2010, 06:13 PM posted to microsoft.public.excel.misc
Martin ©¿©¬ @nohere.net
external usenet poster
 
Posts: 241
Default 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  
Old March 26th, 2010, 06:40 PM posted to microsoft.public.excel.misc
Martin ©¿©¬ @nohere.net
external usenet poster
 
Posts: 241
Default 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  
Old March 26th, 2010, 06:54 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:26 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.