| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help putting left, right, find and len together
I need to pull the following string apart in several different ways and I
can't get the combination of the functions right for it to work. example of string: AB 5X75X200 YD G5487L First - I want to look at the string and pull out the dimensions 5, 75, and 200 and put them in separate cells. character counts will not always be the same Second - YD may not always be YD it could also be LY Third - I need to start at the right find the space and pull everything out to the right of the space. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find max then sum cells above & to the left? | Excel Worksheet Functions | |||
| Use of Find with Left, Mid, Right functions in nested IF(and('s | Excel Discussion (Misc queries) | |||
| TO FIND VALUE TO THE LEFT THE CELL USING VLOOKUP OR ANY OTHER | Excel Discussion (Misc queries) | |||
| Find LARGE, and th cell 3 cells to the left? | Excel Worksheet Functions | |||
| FIND or LEFT or MID to swap first name with last name? | Excel Worksheet Functions | |||
Threaded Mode
