| 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
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 |
|
#4
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
thks, never knew such existed
|
|
#6
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 |
|
#7
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 |
|
#8
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 |
|
#9
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 |
|
#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 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
Dave,
Then I'm baffled, there is no way i can break your (or any other hyphenated) string with line wrap enabled (including using any of the other non breaking characters I posted earlier) either by adjusting column width or adding extra strings at the start ot the string. For good order 2003 (911.8211.8202) SP3 I've googled it and found a website http://www.maysstuff.com/excel/new07.html But have no idea who this guy is, he claims this is new in 2007 but I don't have that and it works (Honest) Perhaps someone else out there can explain Mike "Dave Peterson" wrote: 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 |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
I'm guessing that 911.8211.8202 SP3 is a typo--11.8211.8202 SP3 is what I see
under Help|about MS Excel. And I loaded up xl2007 and could do the same thing I could do in xl2003. Just to make sure we're talking about the same look: In my example, I'd see this in a cell. asdf-qwer I could make it look like: asdf-qwe r asdf-qw er asdf-q wer asdf- qwer even: asdf -qw er Mike H wrote: Dave, Then I'm baffled, there is no way i can break your (or any other hyphenated) string with line wrap enabled (including using any of the other non breaking characters I posted earlier) either by adjusting column width or adding extra strings at the start ot the string. For good order 2003 (911.8211.8202) SP3 I've googled it and found a website http://www.maysstuff.com/excel/new07.html But have no idea who this guy is, he claims this is new in 2007 but I don't have that and it works (Honest) Perhaps someone else out there can explain Mike "Dave Peterson" wrote: 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 -- Dave Peterson |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
Dave that was a typo, our systems are the same.
Two near identical strings A1= the quick brown fox jumped over the lazy-Â*dog A2= the quick brown fox jumped over the lazy-Â*dog A1 hyphen A0173 A2 standard heyboard hyphen When column A is slowly narrowed on my system A1 gives a classic demonstration of a non-breaking hyphen. Mike "Dave Peterson" wrote: I'm guessing that 911.8211.8202 SP3 is a typo--11.8211.8202 SP3 is what I see under Help|about MS Excel. And I loaded up xl2007 and could do the same thing I could do in xl2003. Just to make sure we're talking about the same look: In my example, I'd see this in a cell. asdf-qwer I could make it look like: asdf-qwe r asdf-qw er asdf-q wer asdf- qwer even: asdf -qw er Mike H wrote: Dave, Then I'm baffled, there is no way i can break your (or any other hyphenated) string with line wrap enabled (including using any of the other non breaking characters I posted earlier) either by adjusting column width or adding extra strings at the start ot the string. For good order 2003 (911.8211.8202) SP3 I've googled it and found a website http://www.maysstuff.com/excel/new07.html But have no idea who this guy is, he claims this is new in 2007 but I don't have that and it works (Honest) Perhaps someone else out there can explain Mike "Dave Peterson" wrote: 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 -- Dave Peterson |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Non Breaking Hyphen in 2003
Thanks.
I see it now. It seems to work ok until the column width is too narrow for "lazy-dog". Mike H wrote: Dave that was a typo, our systems are the same. Two near identical strings A1= the quick brown fox jumped over the lazy-Â*dog A2= the quick brown fox jumped over the lazy-Â*dog A1 hyphen A0173 A2 standard heyboard hyphen When column A is slowly narrowed on my system A1 gives a classic demonstration of a non-breaking hyphen. Mike "Dave Peterson" wrote: I'm guessing that 911.8211.8202 SP3 is a typo--11.8211.8202 SP3 is what I see under Help|about MS Excel. And I loaded up xl2007 and could do the same thing I could do in xl2003. Just to make sure we're talking about the same look: In my example, I'd see this in a cell. asdf-qwer I could make it look like: asdf-qwe r asdf-qw er asdf-q wer asdf- qwer even: asdf -qw er Mike H wrote: Dave, Then I'm baffled, there is no way i can break your (or any other hyphenated) string with line wrap enabled (including using any of the other non breaking characters I posted earlier) either by adjusting column width or adding extra strings at the start ot the string. For good order 2003 (911.8211.8202) SP3 I've googled it and found a website http://www.maysstuff.com/excel/new07.html But have no idea who this guy is, he claims this is new in 2007 but I don't have that and it works (Honest) Perhaps someone else out there can explain Mike "Dave Peterson" wrote: 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 -- 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)
Linear Mode
