Sorry, I wasn't paying attention. The formula will
extract the last word. Use this instead:

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

Also array-entered.

Jason

-----Original Message-----
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

.

.