Excel 2007 VB Code To Remove Text String
Posted on 2015-01-28
Hoping someone can assist in developing a VB code that will do the following:
Column A contains a number of rows of text. The text begins with an employees name (semi-colon;) employee ID (semi-colon;). For example: John Doe; 12345;
I'd like the code to look at each row in Column A that contains text and remove the employees name, semi-colon, employee ID, semi-colon. Basically if the code could somehow identify the second semi-colon and remove all text to before and including that point it would be ideal.
Any assistance would be appreciated. Thanks!