One way:

=RIGHT(A1,MATCH(" ",MID(A1,LEN(A1)+1-ROW(INDIRECT("1:"&LEN
(A1))),1),0)-1)

Array-entered (press ctrl + shift + enter).

HTH
Jason
Atlanta, GA

-----Original Message-----

Can someone give me a formula to delete last word in a
column?

Thanks
roger901


--
roger_home
---------------------------------------------------------
---------------
roger_home's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=16434
View this thread:
http://www.excelforum.com/showthread...hreadid=346091

.