Koala20171990
New Member
- Joined
- Oct 20, 2017
- Messages
- 6
Hi all,
Another quick question: I currently have a spreadsheet that has a year column and an effective date column which has the month and day. I'm looking for a macro that will merge the two columns into one with the format (month-day-year). Any advice is greatly appreciated!
Right now, the format looks like this:
<tbody>
</tbody><colgroup><col><col></colgroup>
Another quick question: I currently have a spreadsheet that has a year column and an effective date column which has the month and day. I'm looking for a macro that will merge the two columns into one with the format (month-day-year). Any advice is greatly appreciated!
Right now, the format looks like this:
Year | Effective Date |
2000 | 19-May |
1-Jul | |
2001 | 19-May |
Thanks! | 1-Jul |
<tbody>
</tbody><colgroup><col><col></colgroup>