Text Problem.

Nigel Martin · Apr 8th, 2002, 06:07 AM

I have a spreadsheet with columns containing names and addresses etc. with the last column containing a large amount of text. This text can be upward of 1000 characters I know it can be spread over various columns but that does not seem very proffesional to me. Any ideas. Or is it a job for MS Access with its memo field facility ?

Anne Troy · Apr 8th, 2002, 06:23 AM

Sounds like you should be doing this in Word. If you don't have calculations or other numeric data, then Word should handle it far better for you.

Likely, you can select all cells in Excel, copy, then paste right into a Word document and it should paste as a table. You may need/want to adjust some column widths, set the page setup to print landscape or even landscape legal.

_________________
TheWordExpert

[ This Message was edited by: Dreamboat on 2002-04-08 05:24 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 06:07 AM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	I have a spreadsheet with columns containing names and addresses etc. with the last column containing a large amount of text. This text can be upward of 1000 characters I know it can be spread over various columns but that does not seem very proffesional to me. Any ideas. Or is it a job for MS Access with its memo field facility ?

Apr 8th, 2002, 06:23 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Sounds like you should be doing this in Word. If you don't have calculations or other numeric data, then Word should handle it far better for you. Likely, you can select all cells in Excel, copy, then paste right into a Word document and it should paste as a table. You may need/want to adjust some column widths, set the page setup to print landscape or even landscape legal. _________________ TheWordExpert [ This Message was edited by: Dreamboat on 2002-04-08 05:24 ]