Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list of 3 letter codes (about 60 of them) that don't change. I
also have a bunch of strings exported from an application that contain one of the 3 letter codes. All three letter codes are Caps and the exact location of the code changes within each string. I was wondering if there was an easy way to find out which code is in the string. For example I have the list of codes in Sheet 2... A B COU COUNTER CHANGE OUT CUR CURB REPLACEMENT DEC DECK/PATIO DEM DEMOLITION And one of my strings in sheet 1 looks like... A 13268 05/05/2008 5841 S LAGRANGEI OWNER: KEN HOOK 5 E AYERS HINSDALE,IL 60521 DEM *** 9,500.00 M & R DEMOLITION, INC. DEM B-3 400.00 Thanks in advance for any help Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search for string of characters in a cell | Excel Discussion (Misc queries) | |||
search if a string contains text matching items in a list | Excel Worksheet Functions | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
Using Vlookup in a string search of a cell | Excel Worksheet Functions |