Hi everyone,
Can I please get a solution on how to split the cell below in to two by the two? I am data cleaning addresses and some columns are meged into one, like for example street name and town, and the only way to tell these is identifying a word with two capitalised letter. I have tried other formula, but it is not as efficient and fails to rectify the problem; see below for an exaples and it will be great, if you can help me out please.
MillmountLa Charroterie
Rainbow's EndRoute Des Landes
Copse EndWitham Road
Iltney LodgeNew Hall Lane
Great Grove FarmMurray Road
Thank you.