| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT
I've transformed my pdf statements into text and put into excel 2007. All
entries are similar to this: 12/16 12/18 254WW17PGA84HM5V3 NAME OF BUSINESS LOCATION AMOUNT the two dates are always 11 characters but the next set of bank numbers vary in length. what I want to extract is the text for the payment info to the right of space 3 to cut out all the lead in. I've tried several functions and combinations but can't seem to hit it. Any help is appreciated. thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Text with Left, Mid, etc | Excel Worksheet Functions | |||
| Extract name before comma, space & number | Excel Discussion (Misc queries) | |||
| How to extract left-most number from a string | Excel Worksheet Functions | |||
| Need to pick up data from left of a space starting from the right? | Excel Discussion (Misc queries) | |||
| space left for future entry = #DIV/0! | New Users to Excel | |||
Threaded Mode
