C
Carol
Is it possible to insert a non breaking hyphen in Excel 2003?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jarek Kujawa
what is a non breaking hyphen?
M
Mike H
Hi,
Press & hold ALT then 0173 on the numeric key pad will insert a non-breaking
hyphen.
Mike
Press & hold ALT then 0173 on the numeric key pad will insert a non-breaking
hyphen.
Mike
M
Mike H
Its a hyphen that ensures a hyphenated words stays on one line
J
Jarek Kujawa
thks, never knew such existed
M
Mike H
You can try these additional non breaking characters
ALT 0160 space
ALT 0150 dash
ALT 0151 dash
Mike
ALT 0160 space
ALT 0150 dash
ALT 0151 dash
Mike
D
Dave Peterson
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.
columnwidth, you can make it break at any character.
M
Mike H
Did you try ALT 0173 ?
Dave Peterson said: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.
G
Gord Dibben
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
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
D
Dave Peterson
Yep.
Did you format the cell to wraptext?
Did you change the columnwidth?
Did you format the cell to wraptext?
Did you change the columnwidth?
Mike said:Did you try ALT 0173 ?
M
Mike H
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
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
D
Dave Peterson
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.
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 said: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
M
Mike H
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
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
D
Dave Peterson
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
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 said: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 said: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.
M
Mike H
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
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 said: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 said: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
D
Dave Peterson
Thanks.
I see it now. It seems to work ok until the column width is too narrow for
"lazy-dog".
I see it now. It seems to work ok until the column width is too narrow for
"lazy-dog".
Mike said: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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.