ExcelBanter - Deletting last work from Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Deletting last work from Cell (https://www.excelbanter.com/excel-discussion-misc-queries/253983-deletting-last-work-cell.html)

Linexe

Deletting last work from Cell

Hi

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

For example my cells read M04274059519 Total

Ron Rosenfeld

Deletting last work from Cell

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

All times are GMT +1. The time now is 12:55 PM.