search for single character+space at beginning of string
I am searching for a single character at the start of of a sentence in excel. E.g. suppose Cell A1 contains string "T code999" A2 contains "WWW T 8" A3 contains "TW"
WHen I search for the string "T " (T followed by space) then the result should only show cell A1 (where the string starts with T and there is a space after it) Is there a way to search in excel like this?
I am searching for a single character at the start of of a sentence in excel. E.g. suppose Cell A1 contains string "T code999" A2 contains "WWW T 8" A3 contains "TW"
WHen I search for the string "T " (T followed by space) then the result should only show cell A1 (where the string starts with T and there is a space after it) Is there a way to search in excel like this?
No comments:
Post a Comment