Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting text in a cell
I have a 600 row worksheet were I need to remove the text to the left of the
first space in a cell, all are different lengths. Is there a formula for that? For example: September 8464-005 pin July 14386 brg May 5028 washer In the above I would need to remove the months from each cell. The only commonality would be the space after the month. End result would be: 8464-005 pin 14386 brg 5028 washer Any help is greatly appreciated! Lee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Text | New Users to Excel | |||
deleting space in cell behind text | Excel Discussion (Misc queries) | |||
Deleting some text from a cell | Excel Worksheet Functions | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel |