Hi folks
Would there be a formula to remove Apostrophe from a name in a cell into a new cell/column?
eg
O'MALLEY to just OMALLEY
CAT O'MOUNTAIN to just CAT OMOUNTAIN
Cheers
Hi folks
Would there be a formula to remove Apostrophe from a name in a cell into a new cell/column?
eg
O'MALLEY to just OMALLEY
CAT O'MOUNTAIN to just CAT OMOUNTAIN
Cheers
Ctrl+H
Find what what: '
Replace with : ( leave Blank)
Replace All - Done
Cheers Pepe!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks