I have 100+ records WS that look exactly like the one attached (except I've only included a single record that has the consistent format for all records/cells. They are all in a single column by cell. I need a macro that can parse the data by Identifying the Name (e.g. John Doe, strip the dash out and spaces, place the title (e.g. Global Director, Business Management) in next column, identify the email and place it in next columnI and place the phone number in next column. In other words, when finished, I have the record with the data in separate cells.
For someone who knows how to manipulate data, I think this may be rather easy. For someone like myself, not so much!
Thank you in advance,