Hi,
I have made a sentence combining different cells in excel via using CONCATENATE Function. When I am copying it and pasting it in the browser or notepad, it adds Quotation Marks. Any ways this can be avoided, so that I dont have to remove the Quotation Marks manually. Which I never wanted in the first place.
Pls Help.
Thanks,
Addy
I just teested on this in A1:A3
aaa
bbb
ccc
I used...
=CONCATENATE(A1," ",A2," ",A3)
and...
=A1&" "&A2&" "&A3
and pasted the "answer" for both of them into notepad - neither gave me quotation marks?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks