Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Add 2 spaces to end of sentance?
As far as I know, neither leading nor trailing spaces will reach Word
from Excel no matter which connection method you use (DDE, ODBC, OLE DB), except maybe the old Excel converter will do it for .xls files. However, if you use Excel Insert tab-Symbol (at the end)-Special Characters to insert "n-spaces", they should reach Word via the default OLE DB connection. If, however, you also need to use DDE to connect, they will be converted into "?" characters. Unfortunately, something also seems to strip "non-breaking space" characters which would probably be a better option as they are the same width (AFAIK) as ordinary spaces. But you may find 2 n-spaces, an m-space+an n-space or some such works for you. Peter Jamieson http://tips.pjmsn.me.uk Lightjag wrote: I have constructed a number of sentences in excel. Each sentence represents a field that I ref in my mail merge doc. Issue: Depending on the situation some sentences are needed and some are not, so putting a double space after each field in word, may result in 4 spaces after a sentance if one field/sentence is not needed. When I add spaces to the sentences in excel, word during the mail merge process removes/ignors the spaces. Any thoughts? Thanks in advance |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to keep a portion of a sentance togeather | Microsoft Word Help | |||
Linking a certain cell in Excel to a certain spot in a sentance in | Microsoft Word Help | |||
Adding words to sentance? | Microsoft Word Help | |||
How do I get word to use uppercase on each new sentance | New Users | |||
i need a sentance for capital? | Microsoft Word Help |