Hi All.

I would be very grateful if someone could help with the following:

I am looking for a formula that separates cells by capital letter:

so If I have "BlueShoes", I would end up with cells containing "Blue" and "Shoes".

I need this for varying lengths of words, so for example "ReallyBloodyNiceBlueShoes" would be split to "Really", "Bloody", "Nice" and "Shoes".

I have found the attached file online, however, I can't work out how to adjust it for words with more that two words.

Positive feedback will be given for all help.

Thanks in advance.

Ryan.

16391_Splitting data in cells with capital letters.xls