How do I remove spaces in a table in Word linked from Excel

W

wjh514

How do I remove spaces in a table in Word linked from Excel. Whenever I
update values in Word in a table that links to Excel. It brings in the
spaces from the original cell as blank characters. How do I remove these or
keep it from bringing them in in the first place?
 
M

macropod

If you're linking to a range of cells in Excel, some of which are empty, you
can't avoid linking to the empty one as well.

The only way around this is to only link to the cells that have values -
which can be a problem if they keep changing from empty to filled.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
(Word 2016/365) Removing white space between pages at a smaller zoom 0
Embed the same Excel multiple times 0
Linking data in MS Word into Excel 5
How to remove a bracket that is itallicised for an entire document 1
Formating bolded text exclusively. 0
List all tables, including document structure 0
Auto-Numbering in a Table in MS Word 1

Top