THE PROBLEM: You are given a list of email addresses and you wish to extract the First Name, Surname and Company Name from the list. The majority of the emails come in the format firstname.surname@company.com. Separating the information manually will be time consuming; you need a quick solution.
THE SOLUTION: Use the Text to Columns function as per the screenshots below…
THE SOLUTION: Use the Text to Columns function as per the screenshots below…
Posts
