Linking single cell into word, formatting problem

[charles352]

Problem:
When linking a single cell from Excel 2003 to Word 2003 I'm getting a forced line break right after the linked cell data.

Example:
The vacancy rate was 4.5%
in the Western U.S., while it was 2.5%
in California.

There are line breaks after 4.5% and 2.5% that should not be there.

My Procedure:
1. In Excel, copy the cell
2. Go to Word, Paste
3. Use Formatting Box next to pasted text, select "Match Destintation Formatting and Link to Excel"

Other Info
I can do the following...
Clickbehind 4.5% and start typing but Word highlights this text in Grey as part of the Link to Excel. I don't know if that's going to be a problem later, plus it makes it harder to read what is boiler plate vs. dynamic text

Thanks Much!

 

[itchysoul]

Still a problem in Office 2016. Big impediment to some otherwise easy automation. Any good solutions out there?

 

[MoniqueB79]

Were you ever able to resolve your issue? I am having formatting issues myself.