Ian Bell
asked on
Remove apostrophe from text
Hi
I would like a formula modified to remove an apostrophe
Please see attached
Many thanks
Ian
outcome should be
Meccas Gift
remove-apostrophe.xlsx
I would like a formula modified to remove an apostrophe
Please see attached
Many thanks
Ian
outcome should be
Meccas Gift
remove-apostrophe.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Neeraj works perfectly with regards to all anomalies in the text data. Thanks Ejgil for your contribution. I'll look at that more closely when time permits.
Many thanks
Ian
Many thanks
Ian
You're welcome Ian! Glad it worked as desired.
Open in new window