To remove the first word:
=LEFT(A1,FIND(" ",A1)-1)
To remove the second (and last) word:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
How to seperate or remove one of two words from a cell
