Splitting Continuous Text Into Two Cells Using Uppercase Letter As Delimiter

Hi there, i have the following situation. I have some names (see picture). First name should always go into column C, Last name into column B. As seen from the picture it does not always work the way intended. Thus I need a VBA code (sub function) to split those names (i.e MenkeRobert) into First name and last name again whereas the last name needs to be in Column B and the First name in column C again =). Indicator when to split the string is the Capital letter.

Hope you guys can help me

Thank you in advance

Issi

screenshot.PNG

Hi, thanks for the swift reply. Since there is no popup opening on clicking on the attachment icon in advanced i have uploaded the file on google drive - i hope its allowed =).



The name should only be split if Column B is empty (and the full name is glitched into column C).

@Arkadi - I have tested your code, but not all glitched names are splitted - have a test =)

https://drive.google.com/open?id=0B-...XNhMXl6YzhXSlE

Greetings

If this is not how you wanted, need to see your exact result in the workbook.

Please Login or Register  to view this content.

Hey jindon, perfect - its working =). Tested it with all 5000 employees from the wage plan system. Thank you very much !
@YasserKhalil : Getting unknown exception handling error - maybe a typo - but im checking the code profoundly =)

Thank you all for the more than quick solution and greetings from Munich!