As far as I know, multi-line cells in Excel always get copied with double-quotes. How about continuing with the idea in your last paragraph: use a unique character or string instead of CHAR(10) and then replace that character or string with a newline in TextPad?
For example, use the formula ...
Search found 2 matches
- Wed Dec 03, 2008 4:39 pm
- Forum: General
- Topic: Using CHAR(10) inserting quotes ". How do I avoid this
- Replies: 2
- Views: 635
- Wed Dec 03, 2008 4:52 am
- Forum: General
- Topic: Using CHAR(10) inserting quotes ". How do I avoid this
- Replies: 2
- Views: 635
Using CHAR(10) inserting quotes ". How do I avoid this
Hi,
I have lines in excel in the following format:
=concatenate(a1, a2, CHAR(10), a3, a4))
=concatenate(b1, b2, CHAR(10), b3, b4))
I'm using the CHAR(10) as a carriage return. When I copy and past this info into text pad, the carriage return is recognized, but a set of quotes comes across at ...
I have lines in excel in the following format:
=concatenate(a1, a2, CHAR(10), a3, a4))
=concatenate(b1, b2, CHAR(10), b3, b4))
I'm using the CHAR(10) as a carriage return. When I copy and past this info into text pad, the carriage return is recognized, but a set of quotes comes across at ...