| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text String - Specific Characters
I've got a list of data in column "A" that looks like this:
A1 Red 26-57-98P Top Shelf A2 Blue 3-18-46Q Top Shelf A3 Green 46-9-38Z Top Shelf etc.... from the text string, I would like to isolate only the numbers and dashes in new cells in column "B" to look like this: B1 26-57-98P B2 3-18-46Q B3 46-9-38Z Is there a function to do that easily? Thx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to match a text string to a data table, any suggestions? | Excel Worksheet Functions | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| Using 'If' refer to specific words in a cell containing text | Excel Worksheet Functions | |||
| Equation in text string? | Excel Discussion (Misc queries) | |||
| Extracting from a text string | Excel Worksheet Functions | |||
Threaded Mode
