Insert character between lower case & upper case letters (ie. "VeryGood" -> "Very|Good")

Hi All

I would like to insert "|" between a lowercase letter and uppercase letter when there's no space between the two ("BlueRed" -> "Blue|Red")

I have data that looks like this (i underlined the problematic areas):

A1 Jack JonesEnjoys playing cricket
B1 Simon SimpsonGreat at golf
C1 Bob BransonCommitted to improving his game
D1 Dave DixonNot built for sport

I'd like it to look like the following:

A1 Jack Jones|Enjoys playing cricket
B1 Simon Simpson|Great at golf
C1 Bob Branson|Committed to improving his game
D1 Dave Dixon|Not built for sport

Is there a way to achieve this?

Any help would be appreciated, thanks !

In case anyone is interested in a VBA solution using regular expressions. This will replace multiple occurrences. I imagine there are more efficient ways to get the result but the following code was tested and working in Excel 2003.

Please Login or Register  to view this content.

Lewis