Thread: Copy multi-line variable to first empty row
View Single Post
  #52   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Copy multi-line variable to first empty row
Hi Terry,

Am Mon, 03 Feb 2020 18:18:13 +0000 schrieb Terry Pinnell:

Could you take a look at this please to see if you can spot where the
unwanted spaces are coming from?
https://www.dropbox.com/s/rf6q4q7r82...aces.jpg?raw=1

Source.txt looks OK to me. Here's the file I used for that last run:
https://www.dropbox.com/s/mr78694twn...urce.txt?raw=1

there were 1 leading space and a trailing char(13)
Have a look:
https://www.dropbox.com/transfer/AAA...AyjTIJxkeCuAQE


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote