this is what I have typed in cell AP38:
In cells A36 and U45 it says abc123
in cell AC38 it says abc 123-1,2
I expected to get a return value of 1 in cell AP38. Instead it shows 0.
Troubleshooting, I changed the AP38 formula to:
I got a return value of 2, like i expected.
Why am I not getting the result I expect from using the wildcard? Everywhere I look online it shows to add a wildcard to a cell name in the format of "*"&cell&"*"