Lillian,

In column G (or anywhere), enter
=D1&" "&E1&" "&F1
That is a worksheet formula.

If you need a VBA macro, you have to provide more details.

HTH
Anders Silvén

"Lillian" skrev i meddelandet ...
I have big excel spreed sheet, on the columnD is street
#,on the columnE is direction, on the columnF is street
name, example:
D E F
123 S Main street
223 N Hill street

how can I merge DEF together become 123 S main street by
using VBA macro.

thanks.

Lillian