Concatenate

doku

New Member
Joined
May 20, 2007
Messages
22
Not sure if its a duplicate post.
I want to achieve something like this:<HTML><HEAD><Script Langage JavaScript><!---function ViewSource() {var HtmlSource;HtmlSource = document.all.ForSubmit.innerHTML;HtmlSource = RetDeleted(HtmlSource);document.write('<HTML><BODY BGCOLOR=#E0F4EA><CENTER><FORM><TEXTAREA ROWS=30 COLS=90%>');document.write(HtmlSource);document.write('</TEXTAREA></FORM></CENTER></BODY></HTML>');}function CopyToClipBoard() {var HtmlSource;HtmlSource = document.all.ForSubmit.innerHTML;HtmlSource=RetDeleted(HtmlSource);window.clipboardData.setData("Text",HtmlSource);alert('Html source of above image\n\nhas been copied to your clip board\n\nJust paste it into Message Body\n\nIf you cannnot paste source from clip board,\n\nclick [View Source] button and paste manually.');}function RetDeleted(targetstring) {if (targetstring.indexOf(unescape('%0D%0A')) > -1) rcode = unescape('%0D%0A')else if (targetstring.indexOf(unescape('%0A')) > -1) rcode = unescape('%0A')else rcode = unescape('%0D');i = 0;p = '';while (targetstring.indexOf(rcode,i) != -1) {m = targetstring.indexOf(rcode,i);p += targetstring.substring(i,m);i = m + rcode.length;}p += targetstring.substring(i,targetstring.length);return p;}</Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT><BR><BR></CENTER><HR><BR><SPAN id='ForSubmit'>
Book1
ABCD
1InputOutput
2aa,b,c,d,e,f,1,2,3,4,5,6
3b
4c
5d
6e
7f
81
92
103
114
125
136
Sheet1
</SPAN><BR><CENTER><HR><FORM NAME='form1'><INPUT TYPE='Button' value='Please click this button to send the source to clipbord' onClick='CopyToClipBoard();'><INPUT TYPE='Button' value='View Source' onClick='ViewSource();'></FORM><FONT COLOR=#339966 SIZE=2> This free code was written by Colo and Ivan F Moala:[HtmlMaker 2.42] - 15th May 2003</FONT><BR><FONT COLOR=#339966 SIZE=2>Code mods by Ivan F Moala - 15th May 2003</FONT></HR></BODY></HTML>

Please guide me if similar post exist.
Thanks in Advance !!!
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sorry.... I pasted the code at the wrong place....
Worked correctly now....
Thanks....
 
Upvote 0

Forum statistics

Threads
1,215,604
Messages
6,125,792
Members
449,260
Latest member
Mrw1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top