View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
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