Combining Data from 2 Colums to 1 Column

Mar 8th, 2002, 07:14 PM

I have two colums one with Year in 2002
format, another with the month in the 1, 2, 3, 4 format. I need it to be in the MMDDYY format
Column A | B | C | D |
so 2002 | 1 | Data | MoreData|

will be copied to ANOTHER SHEET as

Column A | B | C | D
1/1/2002 | dATA | mORE dATA |

How do I combine this in a macro?

Derek · Mar 9th, 2002, 11:04 AM

Hi
You say you want it in MMDDYY format - where is your data for the day, or is it always the first of the month?
Derek

Mar 11th, 2002, 11:19 AM

Derek,
The data can be formatted as first of the month. Meaning if column A reads 1 (Jan) and B reads 2002, for it to combine it and paste it onto another cell as
1/1/2002. Again if A reads 2 (Feb), B reads 2002..it copies it over as 2/1/2002, etc.
thanks for your help!
vanessa

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 07:14 PM	#1
Guest Posts: n/a	I have two colums one with Year in 2002 format, another with the month in the 1, 2, 3, 4 format. I need it to be in the MMDDYY format Column A \| B \| C \| D \| so 2002 \| 1 \| Data \| MoreData\| will be copied to ANOTHER SHEET as Column A \| B \| C \| D 1/1/2002 \| dATA \| mORE dATA \| How do I combine this in a macro?

Mar 9th, 2002, 11:04 AM	#2
Derek Join Date: Feb 2002 Location: Perth Australia Posts: 1,564	Hi You say you want it in MMDDYY format - where is your data for the day, or is it always the first of the month? Derek

Mar 11th, 2002, 11:19 AM	#3
Guest Posts: n/a	Derek, The data can be formatted as first of the month. Meaning if column A reads 1 (Jan) and B reads 2002, for it to combine it and paste it onto another cell as 1/1/2002. Again if A reads 2 (Feb), B reads 2002..it copies it over as 2/1/2002, etc. thanks for your help! vanessa