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

[Tom S]

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.

 

[Bob I]

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

 

[RagDyeR]

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!
=====================================================

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.