Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find specific info using search string using VBA
An order number is embedded in an email title, e.g., order number in the
email below is 09-11111 09-11111 for Customer Jones The order number is not in the same location in each email title. I am comparing two worksheets to determine the order numbers which do not have corresponding emails. The following works to locate the order number above: Set C = .Find(ReqNum, LookIn:=xlValues) Unfortunately, order numbers have revisions, e.g., 09-11111_2 and 09-11111_3, etc. The find method searches within a string and finds 09-11111 when it comes across an email title containing 09-11111_2. I need it to find the extract string, e.g., 09-11111 and NOT within a revised order number such as 09-11111_2. ========= Example: Find 09-11111 This confirms your orders, 09-11111_2 (should not find 09-11111 in this example) 09-11111 for Customer Jones (SHOULD find 09-11111 in this example) ========== Any help would be GREATLY appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find specific info within a text string using VBA | Excel Discussion (Misc queries) | |||
how we find specific word from string in excel and compaire it. | Excel Worksheet Functions | |||
How to search Excel files based on a specific text string in VBA c | Excel Discussion (Misc queries) | |||
Find a specific formatted string in a cell | Excel Worksheet Functions | |||
Find specific value in a string | Excel Discussion (Misc queries) |