Seperate at upper case

[JLyon_Capcom]

Hi there, Im new to the forum and Excel, hopefully someone can help me with finding a function or formula to help me with a very tedious task that is taking me forever. I currently have a list of thousands of concatenated words which I need to split into separate words/cells at each upper case character.

For example, SubWaterBottleNewEmptyDropGrass needs to be split up into:

Sub
Water
Bottle
New
Empty
Drop
Grass

Any ideas?

 

[pgc01]

Hi
Welcome to the board

I posted a solution to split CamelCase text here (look at post #10 in the thread):

http://www.mrexcel.com/forum/showthread.php?t=423753#10

 

[JLyon_Capcom]

Oh wow, thanks so much for the quick response! I didnt think to search for camelcase. This will save me so much time, thanks again!