| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding data in a text column
I have a column that has a description of each of my inventoried items. The
syntax is not the same for any of them. Each one of these items has a specific section that I need to extract to another column. Since they are not in the same location within the field how would I pull this data out? The data I'm looking for is the "WO# 223900". The 6 digits are not always the same either but the "WO#" is. How can I extract this info from my field? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting; finding numerical data in mixed text. | Excel Discussion (Misc queries) | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| Finding duplicate cell entries in a column of data | Excel Discussion (Misc queries) | |||
| Finding last cell with data in a column | Setting up and Configuration of Excel | |||
| Finding Duplicate text strings with a single column | Excel Worksheet Functions | |||
Threaded Mode
