Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
wjh514
 
Posts: n/a
Default How do I remove spaces in a table in Word linked from Excel

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?
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod
 
Posts: n/a
Default How do I remove spaces in a table in Word linked from Excel

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


"wjh514" wrote in message
...
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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Autoresize a copied Excel table lincoln Tables 1 April 7th 06 09:17 AM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM
How to allow Word table to expand or reduce when linked to excel Nicki King Tables 4 February 10th 06 05:15 PM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM


All times are GMT +1. The time now is 07:54 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"