Non Breaking Hyphen in 2003
 

Is it possible to insert a non breaking hyphen in Excel 2003?
--
Carol A. Bratt, MCP

Non Breaking Hyphen in 2003
 

what is a non breaking hyphen?

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

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?

Non Breaking Hyphen in 2003
 

thks, never knew such existed

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

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

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

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

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

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

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

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

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

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

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