How to merge excel using vba
Darren:
Now I hide my D,E,F columns, I do not know how to
unhide, those columns is gone, how did I put back.
Lillian
-----Original Message-----
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
.
.
|