| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup last character of 102 char field
If your data starts in B2, enter this in A2 and copy down
=OR(RIGHT(B2)={"A","C"}) Then use autofilter on column A to filter for FALSE and delete the rows. Then turn off autofilter. "splat" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup last character of 102 char field
Thanks JMB, It works great.
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup last character of 102 char field
Good to hear.
"splat" wrote: Thanks JMB, It works great. |
| Reply |
| 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) | |||
Linear Mode
