![]() |
|
#1
|
|||
|
|||
|
Hello, I’m trying to find a formula that will extract any “-“ that is sandwiched between any two characters that are not spaces. i.e. Q-5, h-k, 9-0. I was thinking this would work to find them, =SEARCH("?-?",B2), but it does not because apparently a blank space qualifies as a character in this case. It would be helpful if the formula would work for more than one instance of the situation in any given string if the situation occurred more than once. Thank you |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Search and replace, with paragraphs and wildcards
|
alex100 | Word VBA | 3 | 05-16-2020 08:43 AM |
Search and replace wildcards
|
eduzs | Word VBA | 2 | 06-29-2019 03:01 AM |
Need Search and Replace Help w Wildcards
|
Oberstfunster | Word | 2 | 12-06-2018 09:28 AM |
| Wildcards used for Search and Replace | ChrisRick | Word | 2 | 03-09-2017 05:01 AM |
Search with wildcards
|
imag | Word | 1 | 11-05-2014 11:42 PM |