Formating text in cells

[Guest]

Hello, does anyone know how to force Excel to keep the hyphen or dash
character (-) with the associated numbers when putting multiple dash-#s in a
cell and turning "wrap" formating on? This is the same problem I have in
Word; when I add dash-#s (ie; -xxx, -yyy, -zzz) Office apps interpret dashes
( - ) as a hypehen to a word and will keep the dash/hyphen on the line above
until there are enough characters to force the dash/hyphen to the next line.
In my work we use the format; -xxx, -yyy, -zzz to denote multiple versions of
the same base part. Work instructions to operators need to include the dash
character (-) for clarity as this is used in inputs to other software.
Thanks so much, Makr

 

[Guest]

this may be a second response
use <insert><symbol><special character> Nonbreaking hyphen

 

[Dave Peterson]

In MSWord, you can use ctrl-shift-hyphen to use a non-breaking hyphen.

But excel doesn't make such a good word processor. If you skinny the column
enough, excel will break the word anywhere.

In xl, maybe you could use a symbol that looks like a hyphen--but isn't anything
special.

="asdf"&char(173)&"qwer"
looked like:
asdf-qwer
In Arial, that is.

alt-0173
if you're typing a string.

ps.

In excel, I would just force a new line where I wanted using Alt-Enter.

 

[Dave Peterson]

That showed as a little square for me (with an arial font, anyway).