Help for VBA Text Merge
 

Please help to code the following

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

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

the results displayed in A1; A2; etc

There are no blank cells in the B col range.

TIA

Ron

Help for VBA Text Merge
 

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

HTH
Cordially
Pascal

"Ron" a écrit dans le message de news:
...
Please help to code the following

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

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

the results displayed in A1; A2; etc

There are no blank cells in the B col range.

TIA

Ron

Help for VBA Text Merge
 

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, "papou" <cestpasbon@çanonplus
wrote:

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

HTH
Cordially
Pascal

"Ron" a écrit dans le message de news:
...
Please help to code the following

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

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

the results displayed in A1; A2; etc

There are no blank cells in the B col range.

TIA

Ron