| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a hard return in a =CONCATENATE formula in excel | Excel Worksheet Functions | |||
| Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
| Migrating Office XP EXCEL files to Office 2007 | Setting up and Configuration of Excel | |||
| In Office 2007 how do you insert a checkbox | Excel Discussion (Misc queries) | |||
| How do I insert a "hard return" in a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
