You can get around the deletion problem as follows:

Select Column G, and click Copy.
(Don't change the selection)
Then Edit menu - Paste Special - Values

Darren

"Lillian" wrote in message
...
I did try your formula, the all the data is in columnG,
but if I try to delete D,E.F column, then G column
become no readable, because is point to =D1&" "&E1&" "&F1
, so I have to hide the D,E.F column, it's ok, but look
funny on the database, the best way is using VBA code, do
you know how to do that, I really appreciated it.


Lillian
-----Original Message-----
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
.