Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i combine three columns in excel. | Excel Worksheet Functions | |||
how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
How to combine two columns? | Excel Worksheet Functions | |||
How do you combine two columns to one? Help!!!!!! | Excel Discussion (Misc queries) | |||
combine columns | Excel Worksheet Functions |