In Office 2007 Excel, is there a way to insert a hard hyphen?
 

I want to insert a hard hypen to keep a hyphenated word together, not have
the word separate to a new line. Also, if there are keystrokes that will do
this, as opposed to using the mouse, I'd like to know what those strokes are.
Thank you.

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

Ctrl + Shift + hyphen for MS Word

Since Excel is not a word processor it is not available in Excel


--


Regards,


Peo Sjoblom




"Deeny H" wrote in message
...
I want to insert a hard hypen to keep a hyphenated word together, not have
the word separate to a new line. Also, if there are keystrokes that will
do
this, as opposed to using the mouse, I'd like to know what those strokes
are.
Thank you.

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

Insert Tab, Symbol, En Dash from the ribbon.
Or Alt+0150 from the numeric keyboard (with num lock turned on).
Or ="Some text"&char(150)&"some more text"
Hope this helps...

"Deeny H" wrote:

I want to insert a hard hypen to keep a hyphenated word together, not have
the word separate to a new line. Also, if there are keystrokes that will do
this, as opposed to using the mouse, I'd like to know what those strokes are.
Thank you.

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

That will not keep the hyphenated word together, that is just the same look
but it doesn't work the same was as in word


--


Regards,


Peo Sjoblom


"BoniM" wrote in message
...
Insert Tab, Symbol, En Dash from the ribbon.
Or Alt+0150 from the numeric keyboard (with num lock turned on).
Or ="Some text"&char(150)&"some more text"
Hope this helps...

"Deeny H" wrote:

I want to insert a hard hypen to keep a hyphenated word together, not
have
the word separate to a new line. Also, if there are keystrokes that will
do
this, as opposed to using the mouse, I'd like to know what those strokes
are.
Thank you.

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

It works for me in Excel 2007... not only looks the same, but with WordWrap
on, works the same. The word will not break at the hyphen. The entire
hyphenated word will wrap to the next line...

"Peo Sjoblom" wrote:

That will not keep the hyphenated word together, that is just the same look
but it doesn't work the same was as in word


--


Regards,


Peo Sjoblom


"BoniM" wrote in message
...
Insert Tab, Symbol, En Dash from the ribbon.
Or Alt+0150 from the numeric keyboard (with num lock turned on).
Or ="Some text"&char(150)&"some more text"
Hope this helps...

"Deeny H" wrote:

I want to insert a hard hypen to keep a hyphenated word together, not
have
the word separate to a new line. Also, if there are keystrokes that will
do
this, as opposed to using the mouse, I'd like to know what those strokes
are.
Thank you.

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

Char(150) is a non-braking *dash*, about twice the size of Char(45), the
standard keyboard hyphen.

A non-breaking hyphen is Char(173), same size as Char(45).

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"BoniM" wrote in message
...
It works for me in Excel 2007... not only looks the same, but with
WordWrap
on, works the same. The word will not break at the hyphen. The entire
hyphenated word will wrap to the next line...

"Peo Sjoblom" wrote:

That will not keep the hyphenated word together, that is just the same
look
but it doesn't work the same was as in word


--


Regards,


Peo Sjoblom


"BoniM" wrote in message
...
Insert Tab, Symbol, En Dash from the ribbon.
Or Alt+0150 from the numeric keyboard (with num lock turned on).
Or ="Some text"&char(150)&"some more text"
Hope this helps...

"Deeny H" wrote:

I want to insert a hard hypen to keep a hyphenated word together, not
have
the word separate to a new line. Also, if there are keystrokes that
will
do
this, as opposed to using the mouse, I'd like to know what those
strokes
are.
Thank you.

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

I stand corrected...

"Ragdyer" wrote:

Char(150) is a non-braking *dash*, about twice the size of Char(45), the
standard keyboard hyphen.

A non-breaking hyphen is Char(173), same size as Char(45).

--
HTH,

RD

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

You guys are AWESOME!! Thank you so much for your help--I really wasn't sure
a hard hyphen could be inserted because Excel is not a word processor. Now
I'm going to enter a new question about making macros in Excel.

Thank you !!

"BoniM" wrote:

I stand corrected...

"Ragdyer" wrote:

Char(150) is a non-braking *dash*, about twice the size of Char(45), the
standard keyboard hyphen.

A non-breaking hyphen is Char(173), same size as Char(45).

--
HTH,

RD

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

Thank you... I probably would have kept assuming it didn't work if you hadn't
asked and made me wonder enough to try it. Course then I got so excited that
it worked, I gave you the last code I tried instead of the one you asked for
- my apologies for the confusion.

"Deeny H" wrote:

You guys are AWESOME!! Thank you so much for your help--I really wasn't sure
a hard hyphen could be inserted because Excel is not a word processor. Now
I'm going to enter a new question about making macros in Excel.

Thank you !!

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

Not necessary!! I'm so green due to lack of training for Office 2007, I'm
wasting hours trying to figure out how to do things or where to appropriate
commands that Excel 2003 had but which I cannot seem to access. So if you
got mixed up on which number, big whoop! No problem, and I'm just grateful
that people responded, because now I'm good to goooooo! Thanks!

"BoniM" wrote:

Thank you... I probably would have kept assuming it didn't work if you hadn't
asked and made me wonder enough to try it. Course then I got so excited that
it worked, I gave you the last code I tried instead of the one you asked for
- my apologies for the confusion.

"Deeny H" wrote:

You guys are AWESOME!! Thank you so much for your help--I really wasn't sure
a hard hyphen could be inserted because Excel is not a word processor. Now
I'm going to enter a new question about making macros in Excel.

Thank you !!

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

I promise, once you get over the can't find anything thingy, you'll love
it... or at least I do. :-)
Some helpful things...
Online Interactive: Excel 2003 to Excel 2007 command reference guide
http://office.microsoft.com/en-us/he...491511033.aspx

Downloadable Interactive: Excel 2003 to Excel 2007 command reference guide
http://www.microsoft.com/downloads/d...displaylang=en

Excel Ribbon mapping workbook
http://office.microsoft.com/en-us/ex...101030621033#3

And you may already be beyond this, but I have a Quick Ref Guide (.doc file)
you can download from he
http://www.maysstuff.com/excel/

Have a great weekend!

"Deeny H" wrote:

Not necessary!! I'm so green due to lack of training for Office 2007, I'm
wasting hours trying to figure out how to do things or where to appropriate
commands that Excel 2003 had but which I cannot seem to access. So if you
got mixed up on which number, big whoop! No problem, and I'm just grateful
that people responded, because now I'm good to goooooo! Thanks!

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

Boni, THANK YOU for all your help and the sites to consult. Are there
similar sites for Word? I'm trying to use a template for mailing labels but
would like to see the lines around those labels, but not lines that print.
That site that allows one to hover over a task in 2003 and then shows one
where the same thing is in 2007 is nothing short of a Godsend! After this
I'll quit bugging you!


"Deeny H" wrote:

I want to insert a hard hypen to keep a hyphenated word together, not have
the word separate to a new line. Also, if there are keystrokes that will do
this, as opposed to using the mouse, I'd like to know what those strokes are.
Thank you.

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

There are similar tools available for most Office Applications... I have them
linked from this page:
http://www.maysstuff.com/07comref.html
and you're not bugging me, I'm happy to help!
As for the lines... click in one of the labels and from the ribbon - Table
Tools Layout Table Group View Gridlines
those are for display only and do not print.
Have a good day!

"Deeny H" wrote:

Boni, THANK YOU for all your help and the sites to consult. Are there
similar sites for Word? I'm trying to use a template for mailing labels but
would like to see the lines around those labels, but not lines that print.
That site that allows one to hover over a task in 2003 and then shows one
where the same thing is in 2007 is nothing short of a Godsend! After this
I'll quit bugging you!


"Deeny H" wrote:

I want to insert a hard hypen to keep a hyphenated word together, not have
the word separate to a new line. Also, if there are keystrokes that will do
this, as opposed to using the mouse, I'd like to know what those strokes are.
Thank you.

In Office 2007 Excel, is there a way to insert a hard hyphen?
 

Boni, no WONDER you are such a marvel and know so much about MS! (I
consulted your site via the link you provided.) I really, really appreciate
your help. My latest project (labels) has gone slowly, but the only real
problem I've encountered is that the name of the college or university crops
up twice on one label--sometimes the lines are one below the first
(mentioning the institution), other times the duplicate line will be down a
couple from the first. All the names and addresses are identical in
composition in an Excel database, so who knows why the college (and only the
college) would pop up is a real conundrum. I'm just going through the labels
manually and removing the offending lines. Thanks again!

"BoniM" wrote:

There are similar tools available for most Office Applications... I have them
linked from this page:
http://www.maysstuff.com/07comref.html
and you're not bugging me, I'm happy to help!
As for the lines... click in one of the labels and from the ribbon - Table
Tools Layout Table Group View Gridlines
those are for display only and do not print.
Have a good day!

"Deeny H" wrote:

Boni, THANK YOU for all your help and the sites to consult. Are there
similar sites for Word? I'm trying to use a template for mailing labels but
would like to see the lines around those labels, but not lines that print.
That site that allows one to hover over a task in 2003 and then shows one
where the same thing is in 2007 is nothing short of a Godsend! After this
I'll quit bugging you!


"Deeny H" wrote:

I want to insert a hard hypen to keep a hyphenated word together, not have
the word separate to a new line. Also, if there are keystrokes that will do
this, as opposed to using the mouse, I'd like to know what those strokes are.
Thank you.