Use =IfNA((formula),Whatever you want to happen if it finds the error)
"" would mean it does nothing - it shows a blank cell
And they are right - trim should get rid of what you are looking for. But you can also download a little adding - will get the name for you.
Actually they have removed it. I used Power Query for most things these days.
Use Power Query's fuzzy matching logic when comparing columns for merging tables.
support.microsoft.com
You can specify how close your match should be. Much like the tool used to do. Blame age. I have it loaded on the other machine - but that is not with me right now.
https://appsource.microsoft.com/en-us/product/office/wa200004933?tab=overview
They never used to charge for it
Sign up with Google