| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a word from a Cell
Hi
Can anyone help, i am trying to deletel the last word from a Cell My cell currently read: - M04274059519 Total and I need a formula that will delete the "total" word Would really appreciate some help linexe |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting a word from a Cell
On Jan 21, 7:27*am, Linexe wrote:
Hi Can anyone help, i am trying to deletel the last word from a Cell My cell currently read: - *M04274059519 Total and I need a formula that will delete the "total" word Would really appreciate some help linexe CTRL+F (find replace) " Total" for "" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting a word from a Cell
CTRL+F (find replace) " Total" for "" Thank you.........Works a treat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make cell equal a word if a data validation cell has a word in it | Excel Discussion (Misc queries) | |||
| deleting phrases in Excel and/or Word | New Users to Excel | |||
| Deleting a Row if it contains a specific word | Excel Discussion (Misc queries) | |||
| Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
| how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Linear Mode
