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.

How do I put a "hard space" into text in a excel 2007 cell?
 

You will have to turn OFF Wordwrap, and seperate each line with Alt+Enter

Tom S wrote:

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.

How do I put a "hard space" into text in a excel 2007 cell?
 

Use the "non-breaking" space, Char(160).

Type
Mr.
Hold the <Alt key and enter
0160
from the Num keypad, *not* the numbers under the function keys, then type
John
And repeat the above procedure,
ending with the typing of
Doe

Char(160) acts as any regular character typed into a cell.
S0, If the column is too narrow to display the entire name, you'll see the
name split to accommodate the width, though it will not necessarily split at
the space.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Tom S" <Tom wrote in message
...
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.