Welsh Mark3
Board Regular
- Joined
- Apr 7, 2014
- Messages
- 164
- Office Version
- 365
I have a file of data where the company name and address are in a single cell over multiple rows. Does anyone have a recommendation to separate each line into its own column?
Line 1 = Company Name
Line 2 = Address
Line 3 = City, State & Zip
Line 1 = Company Name
Line 2 = Address
Line 3 = City, State & Zip
AMERICAN BILLIARDS AND OUTDOOR RECREATIO 312 LEE ST WEST CHARLESTON, WV 25302 USA |
AMERICAN POOL AND SPA 3237 "A" E SUNSHINE SPRINGFIELD, MO 65804 USA |
APOLLO POOLS AND SPAS 8 HARDING ST LAKEVILLE, MA 02347 USA |
APPLIANCES AND MORE 2036 MAIN ST BAKER CITY, OR 97814 USA |