Splitting information in a column

I have a column full of names, addresses, and city/state all in one column, but seperate rows.

EX:

A1 name

A2 street address

A3 city/state

 

I have over 100 addresses that i need to organize into 3 different columns. Is it possible?

By: Mayra

Leave a Reply

Your email address will not be published. Required fields are marked *