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.

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.

"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

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

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.