| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text removal question
I have a column (A1) that has text similar to the following:
Adult Services-DMHAS, Bridgeport A100215249400 I want to take only the text to the right of the last space. The resulting column (A2) would have the following text in it: A100215249400 Can someone tell me the formula for this?-- Thanks You all are teaching me so much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removal of text from a cell containing both text and numbers | Excel Discussion (Misc queries) | |||
| paranthesis removal | Excel Worksheet Functions | |||
| Macro removal | Excel Discussion (Misc queries) | |||
| Number removal | Excel Worksheet Functions | |||
| Year row removal | Excel Worksheet Functions | |||
Threaded Mode
