Help for VBA Text Merge

[Ron]

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

 

[papou]

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]

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