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

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

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

When I read your post, the excel sample looks nicer!

You may want to format that column using a nice fixed width font. (I use
Courier New.)



David wrote:

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


--

Dave Peterson