| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non Breaking Hyphen in 2003
Is it possible to insert a non breaking hyphen in Excel 2003?
-- Carol A. Bratt, MCP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
what is a non breaking hyphen?
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
Its a hyphen that ensures a hyphenated words stays on one line
"Jarek Kujawa" wrote: what is a non breaking hyphen? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
thks, never knew such existed
|
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
You can try these additional non breaking characters
ALT 0160 space ALT 0150 dash ALT 0151 dash Mike "Jarek Kujawa" wrote: thks, never knew such existed |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
Jarek
I don't see the post to which you responded. When replying to a post could you please leave the original post in your reply. Gord On Fri, 18 Jul 2008 06:50:18 -0700 (PDT), Jarek Kujawa wrote: thks, never knew such existed |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
Hi,
Press & hold ALT then 0173 on the numeric key pad will insert a non-breaking hyphen. Mike "Carol" wrote: Is it possible to insert a non breaking hyphen in Excel 2003? -- Carol A. Bratt, MCP |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
I don't think so. If the cell is formatted to wraptext and you change the
columnwidth, you can make it break at any character. Carol wrote: Is it possible to insert a non breaking hyphen in Excel 2003? -- Carol A. Bratt, MCP -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
Did you try ALT 0173 ?
"Dave Peterson" wrote: I don't think so. If the cell is formatted to wraptext and you change the columnwidth, you can make it break at any character. Carol wrote: Is it possible to insert a non breaking hyphen in Excel 2003? -- Carol A. Bratt, MCP -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
Yep.
Did you format the cell to wraptext? Did you change the columnwidth? Mike H wrote: Did you try ALT 0173 ? "Dave Peterson" wrote: I don't think so. If the cell is formatted to wraptext and you change the columnwidth, you can make it break at any character. Carol wrote: Is it possible to insert a non breaking hyphen in Excel 2003? -- Carol A. Bratt, MCP -- Dave Peterson -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
Yep,
With a hyphen inserted using ALT 0173 you wont split a pair of hyphenated words, when they wrap they will do so together and stay on the same line. Using the keyboard hyphen they can split during wrap. Mike "Dave Peterson" wrote: Yep. Did you format the cell to wraptext? Did you change the columnwidth? Mike H wrote: Did you try ALT 0173 ? "Dave Peterson" wrote: I don't think so. If the cell is formatted to wraptext and you change the columnwidth, you can make it break at any character. Carol wrote: Is it possible to insert a non breaking hyphen in Excel 2003? -- Carol A. Bratt, MCP -- Dave Peterson -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
That's not what I saw in xl2003.
I put asdf(alt-0173)qwer in a cell I formatted that cell to wraptext. I could break the first line at each character in the whole string by adjusting the columnwidth. Mike H wrote: Yep, With a hyphen inserted using ALT 0173 you wont split a pair of hyphenated words, when they wrap they will do so together and stay on the same line. Using the keyboard hyphen they can split during wrap. Mike "Dave Peterson" wrote: Yep. Did you format the cell to wraptext? Did you change the columnwidth? Mike H wrote: Did you try ALT 0173 ? "Dave Peterson" wrote: I don't think so. If the cell is formatted to wraptext and you change the columnwidth, you can make it break at any character. Carol wrote: Is it possible to insert a non breaking hyphen in Excel 2003? -- Carol A. Bratt, MCP -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell format - put hyphen where zero value would be. | New Users to Excel | |||
| Trying to use IF statement with hyphen | Excel Worksheet Functions | |||
| Optional hyphen? | Excel Discussion (Misc queries) | |||
| Entering a hyphen into a cell | Excel Worksheet Functions | |||
| ...I want to display a hyphen instead of zero... | Excel Worksheet Functions | |||
![Carol[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
