View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tom S Tom S is offline
external usenet poster
 
Posts: 2
Default How do I put a "hard space" into text in a excel 2007 cell?

I have a worksheet that I am putting text in certain cells -- names,
addresses, etc. These cells are formatted so the text wraps.

Is there a way to place a "hard space" in the text in an excel cell so 2 or
more words in the text box stay together (e.g., "Mr. John Doe" -- I want hard
spaces between each of these words, so the entire name stays on one line in
the cell).

Any help is greatly appreciated.