Please use the body of the post to ask your question.

If I understand your question, a *non-breaking* hyphen is:
CHAR(173)

SO,
="non"&CHAR(173)&"breaking"
will return
non-breaking

While
="up"&CHAR(173)&"to"&CHAR(173)&"date"
will return
up-to-date

Which means that they will be treated as a single, complete word entity.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"up-to-date"
"coultwo" wrote in message
...

I should add, that if you're simply typing data into a cell,
You could use this procedu

"An up-to-date report is lacking."

Type
up
then hold down <Alt, and using the numbers from the num keypad, *not* the
numbers under the function keys, enter
0173
then type
to
then repeat the above sequence,
then type
date

4 digits are needed when using the keyboard.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ragdyer" wrote in message
...
Please use the body of the post to ask your question.

If I understand your question, a *non-breaking* hyphen is:
CHAR(173)

SO,
="non"&CHAR(173)&"breaking"
will return
non-breaking

While
="up"&CHAR(173)&"to"&CHAR(173)&"date"
will return
up-to-date

Which means that they will be treated as a single, complete word entity.

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-


"up-to-date"
"coultwo" wrote in message
...