 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008In 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. Ctrl + Shift + hyphen for MS Word Since Excel is not a word processor it is not available in Excel  SignatureRegards, Peo Sjoblom >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. 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... > 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. 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 SignatureRegards, Peo Sjoblom > Insert Tab, Symbol, En Dash from the ribbon. > Or Alt+0150 from the numeric keyboard (with num lock turned on). [quoted text clipped - 8 lines] >> are. >> Thank you. 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... > 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 [quoted text clipped - 11 lines] > >> are. > >> Thank you. 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). SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > 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 [quoted text clipped - 15 lines] > > >> are. > > >> Thank you. I stand corrected... > 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 !! > I stand corrected... > > > 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). 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. > 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 !! 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! > 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 [quoted text clipped - 6 lines] > > > > Thank you !! 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/details.aspx?FamilyId=89718ABD-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! > 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! 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! > 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. 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, 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 [quoted text clipped - 7 lines] > > this, as opposed to using the mouse, I'd like to know what those strokes are. > > Thank you. 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! > There are similar tools available for most Office Applications... I have them > linked from this page: [quoted text clipped - 16 lines] > > > this, as opposed to using the mouse, I'd like to know what those strokes are. > > > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.