Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 209
Default How to paste and wordwrap a paragraph of text into Excel 2002

jbclem wrote:
I like to save small bits of information, usually messages (answers) from
online forums, into a worksheet I call "misc notes". Trouble is when I do
this, a paragraph of text ends up as one long sentence stretching across
many cells, disappearing off the screen to the right.

I'd like to be able to paste text into a given area, actually into the width
of the screen, and have it wordwrap into the next row when it reaches the
width of the screen. How can I do this? Excel 2002 doesn't even allow the
word "wordwrap" in it's help keyword slot.


John



To me it sounds like you're using the wrong tool for the job. Sort of
like using a monkey wrench to drive a nail. Excel is a program to
manipulate numerical data, not text. Sounds to me like you're building
more of a knowledge base. I use a program called Genral Knowledgebase:

http://www.baltsoft.com/

Not free but useful in multiple situations. I'm sure with a little
looking you could probably find similar for less or even free.

gls858
Reply
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
Pasting in paragraph of text, but with wordwrap? jbclem Excel Discussion (Misc queries) 7 June 29th 07 01:21 AM
Text Truncated after Paste link in Excel 2002 Amol[_2_] Links and Linking in Excel 1 June 24th 07 02:01 PM
Text Truncated after Paste link in Excel 2002 Amol[_2_] Excel Discussion (Misc queries) 3 June 20th 07 04:06 PM
Can I paste a paragraph of text into a merged cell? TCPohlman Excel Discussion (Misc queries) 3 February 16th 07 06:58 PM
In excel, how do you split /expand text , so appear like paragraph Ket Excel Discussion (Misc queries) 2 January 4th 07 02:23 PM


All times are GMT +1. The time now is 07:49 AM.

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

About Us

"It's about Microsoft Excel"