My addresses are listed like this...
Mcdonald's Restaurants
826 West Walnut Street
Johnson City, TN 37604
423-928-8838
Email:
business profile | phone phone | map & details
--------------------------------------------------------------------------------
Mcdonald's Restaurants
1710 West Market Street
Johnson City, TN 37604
423-929-2291
Email:
business profile | phone phone | map & details
--------------------------------------------------------------------------------
Some are 16 lines and some are 17...
Is there anyway without using complicated macros and without writing a formula for each address seperately b/c there are 200+ to make them....
Column 1:Mcdonald's Restaurants
Column 2:1710 West Market Street
Column 3:Johnson City, TN 37604
Mcdonald's Restaurants
826 West Walnut Street
Johnson City, TN 37604
423-928-8838
Email:
business profile | phone phone | map & details
--------------------------------------------------------------------------------
Mcdonald's Restaurants
1710 West Market Street
Johnson City, TN 37604
423-929-2291
Email:
business profile | phone phone | map & details
--------------------------------------------------------------------------------
Some are 16 lines and some are 17...
Is there anyway without using complicated macros and without writing a formula for each address seperately b/c there are 200+ to make them....
Column 1:Mcdonald's Restaurants
Column 2:1710 West Market Street
Column 3:Johnson City, TN 37604