![]() |
#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
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
alex100 | Word VBA | 3 | 05-16-2020 08:43 AM |
![]() |
eduzs | Word VBA | 2 | 06-29-2019 03:01 AM |
![]() |
Oberstfunster | Word | 2 | 12-06-2018 09:28 AM |
Wildcards used for Search and Replace | ChrisRick | Word | 2 | 03-09-2017 05:01 AM |
![]() |
imag | Word | 1 | 11-05-2014 11:42 PM |