I have all 26 MLB teams in this format:
Baltimore Orioles
Oriole Park
333 West Camden Street
Baltimore, MD 21201
Phone: (410) 685-9800
orioles.com
Boston Red Sox
Fenway Park
4 Yawkey Way
Boston, MA 02215
Phone: (617) 267-9440
redsox.com
redsox.com/beisbol
Chicago White Sox
U.S. Cellular Field
333 West 35th Street
Chicago, IL 60616
Phone: (312) 674-1000
whitesox.com
orgullosox.com
and I would like to get them to the following format in a spreadsheet for doing a mail merge.
City Team Stadium Address 1 City State Zip Phone Website1 Website2
I can do the concatenation on a few teams by hand ( Red Sox, San Fancisco).... but having a tough time figuring this one out.
Any help is appreciated.
Thank you in advance
Bookmarks