Anyone know how to use Text to Columns when the underscore in the data is used as both a space and part of an email address? I know an extra step is involved, I just can't put my finger on it.
Your manager has given you raw contact info that needs to be separated by First Name, Last Name, Email Address and Employee Level. Using the text to columns function, separate this data in the table below.
Eric_Johnson_johnson_eric@company.com_Manager John_Smith_john.smith@company.com_Director Beth_Summers_beth.summers@company.com_associate Miles_Peterson_Miles.peterson@company.com_Partner Jenna_Stone_Jenne_Stone@company.com_Manager Quinn_Cook_Quinn_Cook@company.com_Manager