Hi have alot of data which is duplicated in the same cell with no space in between each duplicate. A cell might contain:

an applean apple


Anyone know how I can split them?