software

Please help to code the following

A B C D
1 bbb
2 ccc
3 kkk
4 yyy

Merge text cells B1 amp; B2;
B3 amp; B4 etc.......

the results displayed in A1; A2; etc

There are no blank cells in the B col range.

TIA

Ron

Hello
You don't need any code for this.
Instead use a formula in A1 :
=B1amp;B2
you can then drag down to your other cells in column A

HTH
Cordially
Pascal

quot;Ronquot; gt; a écrit dans le message de news:
...
gt; Please help to code the following
gt;
gt; A B C D
gt; 1 bbb
gt; 2 ccc
gt; 3 kkk
gt; 4 yyy
gt;
gt; Merge text cells B1 amp; B2;
gt; B3 amp; B4 etc.......
gt;
gt; the results displayed in A1; A2; etc
gt;
gt; There are no blank cells in the B col range.
gt;
gt; TIA
gt;
gt; Ron

Pascal,

Many thanks for your suggestion but I do need the merged text in Col A
to do some more text manipulation, editing and copying.

Best wishes

Ron

On Wed, 17 May 2006 16:30:56 0200, quot;papouquot; lt;cestpasbon@çanonplusgt;
wrote:

gt;Hello
gt;You don't need any code for this.
gt;Instead use a formula in A1 :
gt;=B1amp;B2
gt;you can then drag down to your other cells in column A
gt;
gt;HTH
gt;Cordially
gt;Pascal
gt;
gt;quot;Ronquot; gt; a écrit dans le message de news:
...
gt;gt; Please help to code the following
gt;gt;
gt;gt; A B C D
gt;gt; 1 bbb
gt;gt; 2 ccc
gt;gt; 3 kkk
gt;gt; 4 yyy
gt;gt;
gt;gt; Merge text cells B1 amp; B2;
gt;gt; B3 amp; B4 etc.......
gt;gt;
gt;gt; the results displayed in A1; A2; etc
gt;gt;
gt;gt; There are no blank cells in the B col range.
gt;gt;
gt;gt; TIA
gt;gt;
gt;gt; Ron
gt;