Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find a character in a textstring
I would like to find a character (in my case the letter S) in a list of
textstrings, and then return the textstrings containing "S" , as well as the two other columns that correspond to it . My columns are as follows 36359 LP 21227.78 36360 FLS 16218.75 36361 FS 14471.59 36362 FS 30109.59 36363 FS 7801.26 36364 FAP 29816.75 36365 FLS 16875 So if I wanted to search for "S" in column 2, I would return; 36360 FLS 16218.75 36361 FS 14471.59 36362 FS 30109.59 36363 FS 7801.26 36365 FLS 16875 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace | Excel Worksheet Functions | |||
Find if nth char = specific character.. | Excel Discussion (Misc queries) | |||
Find a character to sort on in an Excel cell if not the 1st charac | Excel Worksheet Functions | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |