Combine

[oleg_v]

Hi
i need a help with a macro.

i have 2 columns first name "com1" and second name "com2"
in first one i have first names and i second last names .
how can i combine the column to one column with first and last name.


thanks

Oleg

[PSL]

Do you really need a macro for that? Simple "&" or "Concatenate" would do the job for you.

=A1&" "&B1

Or just record a macro with the formula. And delete the other 2 columns. If you really need a macro for this that is