| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrap and merge text will not show all lines | Excel Discussion (Misc queries) | |||
| Merge text list | Excel Worksheet Functions | |||
| merge unformatted date with text | Excel Discussion (Misc queries) | |||
| can wrap text and merge be used together? | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
