split a cell......

[KATSALAS]

ok .. i have 2 words in one cell......how can i cut the second word and paste it in a different cell????......(there is a col with 2000 of them)

i appreciate your help guys..

 

[pcc]

check out Data>Text to columns, use a space delimiter

 

[HalfAce]

Another option...
If the cell you wanted to "split" were A1, in another cell you could use:
=RIGHT(A1,FIND(" ",A1)-1)

Hope it helps,
Dan

 

[Dimli]

Assuming the list of two words are in column A.

Copy column A into column B and column C.
Do a find & replace on column B, finding *space replacing with nothing.
Find & replace on column C, finding space*, replacing with nothing

Does that make sense?

 

[KATSALAS]

the all worked.... you guy are life savers THANKS