View Single Post
  #1   Report Post  
David
 
Posts: n/a
Default combine 2 columns

Hallo,

I have 2 columns:

A1
123456 ABCDE
654321 XYZ
098765 XZYZYZYZ

B1
abc
ab
a

I need to combine both and then copy the result to a txt file.
The condition is that A1 should have a fixed width like 20 spaces and then
begin B1 in the txt file.

Result in the txt file:

123456 ABCDE ABC
654321 XYZ AB
098765 XZYZYZYZ A

Any help? Thanks in Advance.

David