Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Versatile "adaptive" formulae? (instead of "hard"coded IF tests) | Excel Discussion (Misc queries) | |||
how do I type "itis" without Excel putting a space "it is"? | Excel Worksheet Functions | |||
Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions |