\Want to separate words

Hello Friends,
I have some query regarding how to separate a words like this "CurrentAssetsLongTerm" as Current Assets Long Term. Since there are no spaces or semi colon, am unable to seperate them. I need to used vlook in the seperated text , so if any of you may help, it would be my pleasure. Could not attempt manually as there are more than 20,000 words like them? Kindly help and revert ASAP.

Regards,
Kamal

Thanks for replying , but the problem is that i dont understand VBA.....Is there any other way out to seperate the words by general excel given formula or group of formulas.

Regards,

Kamal

am Attaching a sample file , kindly revert with the formula or even VBA code with instruction as how to change the range of data .

Hi,

Help in excel required..xlsm
This is the file having the code posted as above

This sheet contains the function which will work as other function only u have to pass a input reference.
if u want to use this function in your system regularly .

create the copy of this file and then save it with any name but having an extention .xlam .and open it and start using this function.
this will create a addin where u r not required to copy paste this Code again and again.


Thanks

thanks ! Thanks a ton. Got it ......Hats off for you .

yes ! Thanks Again .