Split data in a cell
 

Hi can anyone advise how I would go about splitting data in a cell.

EG I have a column that has first and last name in it separated with a
space.

IE

Bob Smith

How would I automatically look at each cell in the row and after the
end of the first name, cut the second name into its own row.

I should then have:

Bob in one cell and in the adjacent cell Smith.

Thanks in advance,

Cheers,

Aaron.

Split data in a cell
 

One way ..
Try on a spare copy
Select the col, then click Data Text to Columns
(Delimited, check "space" in step 2, click Finish)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Slashman" wrote:
Hi can anyone advise how I would go about splitting data in a cell.

EG I have a column that has first and last name in it separated with a
space.

IE

Bob Smith

How would I automatically look at each cell in the row and after the
end of the first name, cut the second name into its own row.

I should then have:

Bob in one cell and in the adjacent cell Smith.

Thanks in advance,

Cheers,

Aaron.

Split data in a cell
 

"Slashman" wrote in message
ups.com...
Hi can anyone advise how I would go about splitting data in a cell.

EG I have a column that has first and last name in it separated with a
space.

IE

Bob Smith

How would I automatically look at each cell in the row and after the
end of the first name, cut the second name into its own row.

I should then have:

Bob in one cell and in the adjacent cell Smith.

Thanks in advance,

Cheers,

Aaron.


Use the menu: Data - Text to Columns ... then follow the wizard. If you
specify 'space' as your delimiter, Excel will do what you requested.

Cheers,

Joerg

Split data in a cell
 

Ahh brilliant, thanks guys it works well.

Cheers,

Aaron.
Joerg wrote:
"Slashman" wrote in message
ups.com...
Hi can anyone advise how I would go about splitting data in a cell.

EG I have a column that has first and last name in it separated with a
space.

IE

Bob Smith

How would I automatically look at each cell in the row and after the
end of the first name, cut the second name into its own row.

I should then have:

Bob in one cell and in the adjacent cell Smith.

Thanks in advance,

Cheers,

Aaron.


Use the menu: Data - Text to Columns ... then follow the wizard. If you
specify 'space' as your delimiter, Excel will do what you requested.

Cheers,

Joerg

Split data in a cell
 

Glad it worked for you, Aaron !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Slashman" wrote in message
oups.com...
Ahh brilliant, thanks guys it works well.

Cheers,

Aaron.