| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
EXTRACTING TEXT
I want to extract some text from a cell. The text can appear anwhere within
the string such as "OCXO STP 2337A VAR 1 10 MHZ". The text always beings with "STP" but can appear as follows: STP 1234 STP 1234A STP-1234 STP-1234A STP1234 STP1234A I have tried the formula =MID(A152,FIND("STP",A152),8) but the MID is looking for 8 characters and the number of characters are variable. Thank you in advance. Esther |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import comma delimited text | Excel Discussion (Misc queries) | |||
| How do I rotate a text box | Charts and Charting in Excel | |||
| Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| Text Boxes | Excel Discussion (Misc queries) | |||
Threaded Mode
