Excel, how do I insert a non-breaking space (ie, January 8) so th.

[Guest]

I am working with a merge letter (WORD) and an accompanying merge list
(EXCEL). In EXCEL one of the items is a date. The date should not break onto
a separate line when it is merged in the WORD document.

How do I insert a hard space in EXCEL that will keep the date together - so
that when WORD inserts the data from EXCEL, it stays together.

I know that WORD recognizes the "carrot s" (^s) as indication not to break
text. However, I can not find such an indicator in Excel.

Can anyone assist me with this?

Thanks SO much!

 

[Joseph Meehan]

I am working with a merge letter (WORD) and an accompanying merge list
(EXCEL). In EXCEL one of the items is a date. The date should not
break onto a separate line when it is merged in the WORD document.

How do I insert a hard space in EXCEL that will keep the date
together - so that when WORD inserts the data from EXCEL, it stays
together.

I know that WORD recognizes the "carrot s" (^s) as indication not to
break text. However, I can not find such an indicator in Excel.

Can anyone assist me with this?

Thanks SO much!

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.