Identify and split Camel Text

Camel Text (CamelText) is best described as text where words that should be separated normally by a space have been pushed together and in every day data analysis need to be reconstructed. This only applies to text where a capital letter was used for each word such as in a title or a persons name for instance. The code analyses the string for a change in case of the letters and splits it out accordingly.

This example runs down a list or range of cells but can be setup as you require to cover an entire worksheet range or a single cell.

This code is used in most datanology database cleansing projects where data may have been merged or corrupted in some way. Contact us using the form or leave a message for assistance with your Excel project.