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

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

I have excel spreed sheet about 50,000 records, all the
addresss in spred in three column, example:
D E F

123 S main street
123 N Hill street
222 W Broadway

so three columns have different address, now I need to
merge to one big column like columnG, (123 S main street),
then removed data from D E F columns, how to write the
macro to do that.

thanks.

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
.

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
.

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
.

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
.



.

Select Columns C to G (so that the hidden D-F columns are within the
selected area).
Then go to Format menu - Column - Unhide.

Darren

"Lillian" wrote in message
...
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
.



.

Thanks I got it.

-----Original Message-----
Select Columns C to G (so that the hidden D-F columns
are within the
selected area).
Then go to Format menu - Column - Unhide.

Darren

"Lillian" wrote in
message
...
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
.



.



.

And you have another reply to your other post, too.

It's a macro solution that would take longer than what you did with the
worksheet formulas <vbg.



Lillian wrote:

Thanks I got it.

-----Original Message-----
Select Columns C to G (so that the hidden D-F columns
are within the
selected area).
Then go to Format menu - Column - Unhide.

Darren

"Lillian" wrote in
message
...
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
.



.



.


--

Dave Peterson