View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default how do I preserve hyphenated words

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
...