Merge fields show as O

[Peter Bellamy]

Office 2010, merging address lines from Excel into a Word document.

Some, not all address lines of an address come in as Os.
The Excel cells contain text and are formatted as text.

I am really puzzled.
Can anyone help, please !!

 

[Peter Bellamy]

Sorry Office 2007 not 2010 !

Found it only does it when the spreadsheet has been opened first ??
Just open Word and it works fine.