Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
BCM
User Panel

Site Notices
Posted: 5/9/2023 3:20:27 PM EDT
I have an Google Sheets of a list of emails that I need help manipulating. In Column A they are all listed as such:

John Jones

Ideally I can cut them so they are three seperate columns (First Name, Last Name, Email), but if this cant be done, how do I just pull the email addresses and delete the rest?
Link Posted: 5/9/2023 3:59:50 PM EDT
[#1]
Under data look for 'split text to columns'
Close Join Our Mail List to Stay Up To Date! Win a FREE Membership!

Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!

You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.


By signing up you agree to our User Agreement. *Must have a registered ARFCOM account to win.
Top Top