Thanks man, wonderful!!
It is deceiving before pasting the result in the txt file. The result looks
like this
in Excel:
123456 ABCDE abc
654321 XYZ ab
098765 XZYZYZYZ a
When copy/pasting it in a txt file:
123456 ABCDE abc
654321 XYZ ab
098765 XZYZYZYZ a
Thanks,
David
"bj" wrote:
try
=A1 & rept(" ",20-len(A1)) & B1
"David" wrote:
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
|