|
How to merge excel using vba
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 |
How to merge excel using vba
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 |
How to merge excel using vba
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 . |
How to merge excel using vba
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 . |
How to merge excel using vba
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 . |
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 . . |
How to merge excel using vba
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 . . |
How to merge excel using vba
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 . . . |
| All times are GMT +1. The time now is 05:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com