Hi KYO

i'm assuming you have data such as
blue cat
black dog
green mouse

and you want to see
cat
dog
mouse
in the adjacent column
if so, then in cell C1 type
=RIGHT(B1,LEN(B1)-SEARCH(" ",B1))

then hold your mouse over the bottom right hand corner of the cell until you
see a +, hold the mouse down and drag this formula down column C as far as
necessary.

then click on the column heading to select all the column and copy it
now click on C1 and choose edit / paste special - values
click OK
and you should have the list you require.

Cheers
JulieD

"KYO" wrote in message
...

Hi,

I need to select the last word in a cell for a whole column (B) and
paste these
words into Column C...

I am new to this forum and excel and any tips would be greatly
appreciated. :)


--
KYO
------------------------------------------------------------------------
KYO's Profile:
http://www.excelforum.com/member.php...o&userid=16120
View this thread: http://www.excelforum.com/showthread...hreadid=275620