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.

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.

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.