On Thu, 21 Jan 2010 04:25:07 -0800 (PST), Linexe
wrote:


Hi

Does anyone know the formula for deleting the last word from the cell

For example my cells read M04274059519 Total


=LEFT(A1,-1+FIND(CHAR(1),SUBSTITUTE(A1," ",
CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
--ron