Hi,
Does anyone know if there is a way to split a cell by Capital letters?
For example, turning IceCream into Ice Cream (ie. Ice and Cream in different cells).
I have attempted this, but I cannot get it to work. Excel keeps on saying there is an error with the formula:
Lets assume on Cell A1 you have the word that needs to be split.
On cell B1 you enter the following function but you need to make sure that you use CTRL+SHIFT +ENTER after entering the function:
=LEFT(A1,SMALL(FIND(CHAR(ROW(INDIRECT("65:90"))),A1&"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),2)-1)
This will only provide you "Ice" as the result on Cell B1.
Then you click on Cell C1 and use the function:
=REPLACE(A1,1,LEN(B1),"")
followed by CTRL +SHIFT +ENTER
This should give you the result as "Cream"
Appreciate the help in advance.
Regards,
KP
