Formating text in cells

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

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

"Mark J. Worden" wrote:

> 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

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.

Mark J. Worden wrote:
>
> 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

--

Dave Peterson

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

bj wrote:
>
> this may be a second response
> use <insert><symbol><special character> Nonbreaking hyphen
>
> "Mark J. Worden" wrote:
>
> > 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

--

Dave Peterson