Splitting one column into two
 

I have a spreadsheet which contains one column of names, (last name,
first name). I would like to split this into two columns so that I will
have the last name in one column and the first name in another so that I
can use either the first or last name in a mail merge.

Is there way to do this?

Thanks--

BJ

Splitting one column into two
 

Are the names seperated by a space? or by a comma?

Data...text to columns....delimited... and then choose what seprates the
names (space, or comma or whatever)
this should split them up for you.


"Big John" wrote:

I have a spreadsheet which contains one column of names, (last name,
first name). I would like to split this into two columns so that I will
have the last name in one column and the first name in another so that I
can use either the first or last name in a mail merge.

Is there way to do this?

Thanks--

BJ

Splitting one column into two
 

Both. As in " Smith, John"

Thanks for the help!!

BJ

tim m wrote:
Are the names seperated by a space? or by a comma?

Data...text to columns....delimited... and then choose what seprates the
names (space, or comma or whatever)
this should split them up for you.


"Big John" wrote:


I have a spreadsheet which contains one column of names, (last name,
first name). I would like to split this into two columns so that I will
have the last name in one column and the first name in another so that I
can use either the first or last name in a mail merge.

Is there way to do this?

Thanks--

BJ

Splitting one column into two
 

Hi,

For your reference
http://office.microsoft.com/en-us/as...498511033.aspx

Does it help?

Epinn


"Big John" wrote in message
et...
Both. As in " Smith, John"

Thanks for the help!!

BJ

tim m wrote:
Are the names seperated by a space? or by a comma?

Data...text to columns....delimited... and then choose what seprates the
names (space, or comma or whatever)
this should split them up for you.


"Big John" wrote:


I have a spreadsheet which contains one column of names, (last name,
first name). I would like to split this into two columns so that I will
have the last name in one column and the first name in another so that I
can use either the first or last name in a mail merge.

Is there way to do this?

Thanks--

BJ