I was able to convert data from one source by using the following formula.
PROPER(SUBSTITUTE(LEFT(IG2,IFERROR(FIND("(",IG2)-1,LEN(IG2))),"'",""))
from
LAURA'S BAIRN(GB)
to
Lauras Bairn
So I tried the same formula on data from a different source and it produces something different.
from
Laura`s Bairn
to
Laura`S Bairn
Any idea how to modify it ? to return same result as in top example ( Lauras Bairn )
Many thanks
Ian
Hi Ejgil,
Thank you kindly, the solution is exactly what I need
Ian
Professor J
Ian,
If you have Excel 2019 or 365 version. you can use the robust formula below. it will eliminate all of the special characters and numbers and will only leave Alphabets A-Z regardless whether it lower case or upper case and a space.
Thank you kindly, the solution is exactly what I need
Ian