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 » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

lastname, first name



 
 
Thread Tools Display Modes
  #1  
Old September 23rd, 2008, 12:44 PM posted to microsoft.public.excel.worksheet.functions
plubeski
external usenet poster
 
Posts: 1
Default lastname, first name

I have a spreadsheet with 400 names listed lastname, firstname in once cell.
Is there a function in Excel that would create two cells, one cell for
lastname, and another cell for firstname? I'm not looking for the individual
cell cut and paste option.

Thanks,

Pete
  #2  
Old September 23rd, 2008, 12:50 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_2_]
external usenet poster
 
Posts: 1,562
Default lastname, first name

Menu DataText To Columns with a delimiter of comma.

--
__________________________________
HTH

Bob

"plubeski" wrote in message
...
I have a spreadsheet with 400 names listed lastname, firstname in once
cell.
Is there a function in Excel that would create two cells, one cell for
lastname, and another cell for firstname? I'm not looking for the
individual
cell cut and paste option.

Thanks,

Pete



  #3  
Old September 23rd, 2008, 01:01 PM posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
 
Posts: 8,419
Default lastname, first name

Hi,

It depends on how the names are seperated. this assumes with a space

First name
=TRIM(LEFT(A1,FIND(" ",A1)))

Last name
=TRIM(MID(A1,FIND(" ",A1),LEN(A1)))

Another way would be to select the column then
data|Text to columns and follow the wizard.

Mike

"plubeski" wrote:

I have a spreadsheet with 400 names listed lastname, firstname in once cell.
Is there a function in Excel that would create two cells, one cell for
lastname, and another cell for firstname? I'm not looking for the individual
cell cut and paste option.

Thanks,

Pete

  #4  
Old September 23rd, 2008, 01:01 PM posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_]
external usenet poster
 
Posts: 1,764
Default lastname, first name

Hi,

You can obtain the desired result by using Data Text to columns. The
steps should be self explanatory

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"plubeski" wrote in message
...
I have a spreadsheet with 400 names listed lastname, firstname in once
cell.
Is there a function in Excel that would create two cells, one cell for
lastname, and another cell for firstname? I'm not looking for the
individual
cell cut and paste option.

Thanks,

Pete


  #5  
Old September 23rd, 2008, 06:19 PM posted to microsoft.public.excel.worksheet.functions
KIM W
external usenet poster
 
Posts: 25
Default lastname, first name

I work a lot with names: We cannot assume the only space would be between
last name and first name because there are many first names with spaces
within them as well as last names with spaces in them.


"Mike H" wrote:

Hi,

It depends on how the names are seperated. this assumes with a space

First name
=TRIM(LEFT(A1,FIND(" ",A1)))

Last name
=TRIM(MID(A1,FIND(" ",A1),LEN(A1)))

Another way would be to select the column then
data|Text to columns and follow the wizard.

Mike

"plubeski" wrote:

I have a spreadsheet with 400 names listed lastname, firstname in once cell.
Is there a function in Excel that would create two cells, one cell for
lastname, and another cell for firstname? I'm not looking for the individual
cell cut and paste option.

Thanks,

Pete

  #6  
Old September 23rd, 2008, 08:09 PM posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
 
Posts: 8,419
Default lastname, first name

We had to assume something because you didn't tell us

"KIM W" wrote:

I work a lot with names: We cannot assume the only space would be between
last name and first name because there are many first names with spaces
within them as well as last names with spaces in them.


"Mike H" wrote:

Hi,

It depends on how the names are seperated. this assumes with a space

First name
=TRIM(LEFT(A1,FIND(" ",A1)))

Last name
=TRIM(MID(A1,FIND(" ",A1),LEN(A1)))

Another way would be to select the column then
data|Text to columns and follow the wizard.

Mike

"plubeski" wrote:

I have a spreadsheet with 400 names listed lastname, firstname in once cell.
Is there a function in Excel that would create two cells, one cell for
lastname, and another cell for firstname? I'm not looking for the individual
cell cut and paste option.

Thanks,

Pete

 




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 12:51 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.