Hi,

1. I would like to concenate some columns in excel xp, automatically
I'll explain:

I get an excel file once a month, and would like the result of on
column to be a join of some other columns but with an added characte
or a string in between.
Is there an elegant way to do so, without the need to enter th
string/character in a seperate column and make a regular concenate?

One row For example: col A contains the value: 123; COL B contains 45
; col C: 789; col d: 10.
I'd like col d to join these columns, with something in between
"123$aa456 of 789 10"

Can I enter in "concenate", not only col name, but also a string.
Also, if I need some spaces instead of just a string in between
Possible? How?

2.My second problem:

How can I do this automatically?
I'd like to create a bottun or something similar, that once pressing o
it, this concenation will take place.
Macro? Is it possible to use sql in excel?Is vba possible to use? how?
Myabe it's not "concenate" that I need to use(?)

Any help will be most welcome.
Thank

--
Message posted from http://www.ExcelForum.com