PC Review


Reply
Thread Tools Rate Thread

concatenate, char(10), and double quotes

 
 
=?Utf-8?B?c3RldmU=?=
Guest
Posts: n/a
 
      18th Aug 2007
A1=hello, A2=world

Both of the following formulas:
=concatenate(A1,char(10),A2)
=A1&char(10)&A2
return

"hello
world"

when pasted into a text file. Is there a way to get rid of the double
quotes? For what it's worth, char(13) gives the same results.

TIA.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?c3RldmU=?=
Guest
Posts: n/a
 
      22nd Aug 2007
Was this question unclear? Or are there just no solutions?
 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      22nd Aug 2007
I'd guess that no one who read it had a solution to share.

But maybe it depends on what you're using for your text editor program.

I got the quotes in NotePad and UltraEdit. But if I pasted into MSWord, then
the quotation marks didn't appear.

And I could copy from MSWord and paste into NotePad without the quotation marks.

Maybe it's time to do some experimenting with other text editors????

steve wrote:
>
> Was this question unclear? Or are there just no solutions?


--

Dave Peterson
 
Reply With Quote
 
=?Utf-8?B?c3RldmU=?=
Guest
Posts: n/a
 
      22nd Aug 2007
I never thought to try MS Word Dave; that's good thinking. I always use a
plain text editor so I don't have to worry about funky formats. The fact that
the quotes don't show up in MS Word indicate (to me) that this is one of
those funky format situations. If that's the case, it would probably be
easiest (in my situation) to live with the quotes and delete them manually or
use MS Word.

While looking for a solution to this bug/feature, I saw a lot of folks
facing the same situation but their circumstances were quite different. They
were trying to generate code (e.g. SQL) whereas this is simply a convenience
issue for me. I'll keep my eye open for a more elegant solution but won't
lose any sleep over it. Thanks again for your input Dave.

.....steve
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate HTML containing double quotes Chas Microsoft Excel Worksheet Functions 4 4th Apr 2009 04:58 PM
char(10) and double quotes JohnE Microsoft Excel Worksheet Functions 2 11th Mar 2009 09:40 PM
Double quotes when concatenating with CHAR(10) jason.handy@gmail.com Microsoft Excel Misc 0 22nd Sep 2006 09:57 PM
Concatenate columns, separated by double quotes =?Utf-8?B?RmVsaWNpYQ==?= Microsoft Excel Worksheet Functions 2 20th Apr 2005 07:48 PM
How to concatenate double quotes xRoachx Microsoft Access VBA Modules 2 6th Oct 2004 04:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:23 AM.