ExcelBanter - linking files with blanks

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - linking files with blanks (https://www.excelbanter.com/excel-discussion-misc-queries/18150-linking-files-blanks.html)

muscogee

linking files with blanks

When I do a paste special to link a source file with some blanks in it to
second file, the blanks show up as zeroes in the second file. How can I link
these files and have the blanks transfer as blanks?

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