| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell formatting won't work | Excel Worksheet Functions | |||
| Cell to cell hyperlinking does not work, please help | Excel Worksheet Functions | |||
| cell lock does not work ?! | Excel Worksheet Functions | |||
| Number of worksheet tabs as cell value? ie 4 work sheets = 4 cell value | Excel Discussion (Misc queries) | |||
| How to merge one cell from many workbooks to one cell on one work | Excel Worksheet Functions | |||
Linear Mode
