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.