Concatenate

  • Thread starter Thread starter Pawan
  • Start date Start date
P

Pawan

Hello...

I have a worksheet with several columns in it. I want to add a new column
at the beginning. Then I need to concatenate three columns with specific
headings. e.g. from all the columns, I have to concatenate columns with
headings "ID", "Name" and "Place". (The sequence of these columns is not
fixed in the worksheet).

ID KEY NAME JOB PLACE
100 500 JOHN T NY
123 567 MARIA P SF

In this case, the new column should be created before "ID" and its contents
will be "100JOHNNY", "123MARIASF" and so on.

Is there any macro to do this automatically?

Thank You
Regards,
Pawan
 
Hi,

Why use a macro when u can simply use a formula ?

Assuming the order of the headings is always the same.
=B1&D1&F1 (where B=ID, D=Name, F=Place)

& copy/paste the formula till where you need it.
HTH,
 
Because, there are number of activities to do with such kind of worksheets
and this is one of them. Manually doing this will take a lot of time.
 
Back
Top