Programming Questions? Ask a Programmer for Answers ASAP
Hi there and welcome to Just Answer, my name is ***** ***** I look forward to helping you.
I’m sorry to hear you're having trouble. I know that can be frustrating. Hopefully, we can get this resolved quickly.
Can you tell me how you try to use it and how it is failing?
If it kinda wors, then the issue is not the formula it is the data.
Check the remaining for items such as blank spaces please, as the formula either works or does not, when it kind of works it is the data thats the issue, and not matching.
Let me know how you go please
Yes the space is an issue.
Do a find and replace in the column, and put in the find a space, and leave the replace empty
It will remove the spaces.
I can also do these steps for you, and have made a request via Additional Services. This is optional, and if you choose to do this, I can, with your permission, remote into your computer while you watch and do all these steps (and deal with any problems that arise during them) for you. Or if you do not choose to take this service, we can continue here. This is no problem at all. Just let me know please.
You are welcome!