| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup last character of 102 char field
Hi All,
I have a data field that has codes that are 102 characters long. 62000 different ones. I need to remove the ones that do not end with A and C. ........359CXAPA I would need to keep in the list ........468CYBMR I need to remove from the list What would be the best way to do this? Thanks Owen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
| Find if nth char = specific character.. | Excel Discussion (Misc queries) | |||
| Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
| Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
| 15 character field truncating | Excel Discussion (Misc queries) | |||
Threaded Mode
