Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract first second "word" from a Cell..
I need to extract the second "word" from a Cell.
The data comes from a database, which I do have some control over. I'm importing into Excel so that I can create new "elements" in order to do charts. One column, which seems so simple, is giving me problems. The first two words in a column will always look like this: PM Smith asdfasdfasfasdf (where asdf... is free text.) I want extract the "Name" and create a new column with this value. I'm hoping to avoid creating a bunch of nested "IF" statements searching for all possible names. Thanks, KSL |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract first to "works" from a Cell. | Excel Worksheet Functions | |||
How to setup "marching ants" border Excel cell? OK in MS Word. | Excel Discussion (Misc queries) | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Why doesn't Excel "word wrap" always expand the cell fully? | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |