| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find String in another string - only between spaces
Hi,
I need to find and return a string in another string only if the searched string is straight A to Z chars in a row. saying A1:A3 is the string to find in B1:B3 is the formula. need to find string "AB" A1: ABDF_ABD A2: ABDF_AB A3: ABDF AB result should be B1 - NA, B2-AB , B3-AB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find string within other string | Excel Worksheet Functions | |||
| Insert spaces in text string in Excel | Excel Discussion (Misc queries) | |||
| Insert spaces in String of Numbers | Excel Worksheet Functions | |||
| List File Properties - Author | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
