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

  • Thread starter Thread starter Deeny H
  • Start date Start date
D

Deeny H

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.
 
Ctrl + Shift + hyphen for MS Word

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


--


Regards,


Peo Sjoblom
 
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...
 
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
 
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...
 
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).
 
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 !!
 
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.
 
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!
 
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/help/HA101491511033.aspx

Downloadable Interactive: Excel 2003 to Excel 2007 command reference guid
http://www.microsoft.com/downloads/...BD-2758-47B3-9F90-93788112B985&displaylang=en

Excel Ribbon mapping workboo
http://office.microsoft.com/en-us/excel/HA100860481033.aspx?pid=CH101030621033#3

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

Have a great weekend!
 
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!
 
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!
 
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!
 
Back
Top