I need a macro that will merge columns D & E and will put a dash in between them
Column D = 457 Column E = 12 Merged Column = 457-12
The sheet I'm merging has 15,000 rows and has blank rows.
I need a macro that will merge columns D & E and will put a dash in between them
Column D = 457 Column E = 12 Merged Column = 457-12
The sheet I'm merging has 15,000 rows and has blank rows.
sorry multiple times posted
---------- Post added at 12:59 PM ---------- Previous post was at 12:55 PM ----------
Hi try this code, Hope it will work
![]()
Please Login or Register to view this content.
Last edited by mmmarks; 08-13-2012 at 01:57 PM. Reason: sorry multiple times posted
If the length of Column e=1 then I need to add a leading zero...... Can this be done?
such as:
Column D = 457 Column E = 2 Merged Column = 457-02
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks