Hi Everyone,
First post, I'm stumped. I have a plain text of employees (made up sample below). It has their name, positions, locations of WFH staff, etc. Each "line" should be a cell, each semicolon should be a new column, each asterisk should begin a new row. I've tried every combination of importing, text-to-columns, etc. This sheet is thousands of lines long and constantly changing. Any ideas about how I could easily separate this out? Thanks in advance!
Jim Smith;
Recruiter;
Washington, DC;
*
Margret Jones;
Human Resources Rep;
Miami Beach, FL;
*
Sally Rice;
Executive Director;
Washington DC;
Current: Executive Director;
*
Ted Brown;
Director of Communications;
Washington, DC;
Director Of Communications;
Follow;
*
Steven Tyler;
Senior Fellow
Baltimore, MD;
Current: Senior Fellow;
*
Thomas Miller
Managing Director ;
Arlington, VA;
*
Jill Davis
Vice President;
Austin, TX;
Vice President of Communication;
*
Bookmarks