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) |