View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LeeE LeeE is offline
external usenet poster
 
Posts: 2
Default How do I convert an Excel Spreadsheet into blocks of Text

I want to convert a spreadsheet that has 9 fields into a block of text.

From this in Line 1 in an excel file (9 fields):
300 Shady Grove 15720 Shady Grove
Rd. Gaithersburg MD 20877 Patrick Cowen 301-948-1390

to this format in Word:
AMERICAN FOLK ART MUSEUM
45 W. 53rd Street, New York, NY 10019
Website:
www.folkartmuseum.org
Contact: Katie Hush
Contact Title: Associate Director of Special Events
Phone: 212-977-7170 ext. 308
Email:

Is there a formula?

Please help. The spreadsheet is in Excel 97-2003 but I have Office 2007.

Thanks,
Lee