LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing 2 blocks of text and data John Fesen Excel Discussion (Misc queries) 2 February 26th 09 09:58 PM
Convert excel spreadsheet data to xml Jaishree Knauff Excel Discussion (Misc queries) 0 April 28th 08 04:10 PM
convert ms works spreadsheet to excel spreadsheet on pda d Excel Discussion (Misc queries) 0 February 20th 06 10:40 AM
Excel formulas to create large blocks of text Greg Boettcher Excel Discussion (Misc queries) 5 June 12th 05 06:41 PM
How do I convert an excel spreadsheet into a pdf? pphelp Excel Discussion (Misc queries) 4 January 9th 05 11:20 PM


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"