thekingoflondon
Board Regular
- Joined
- Sep 22, 2005
- Messages
- 67
OK, so i have a column A. This contains a massive list of dates in the following format:
01-Jan-05
How do I get Excel to generate the same results in column B, but without the day part of the date, leaving only the month and year so it looks like this:
Jan-05
All the information is in a uniform fashion, with 2 digits for the day, a dash, three letters for the month, a dash, and then 2 digits for the year.
I know this is basic stuff, but I am crap with excel, so I would greatly appreciate any help you can give me.
Thanks in advance!!
01-Jan-05
How do I get Excel to generate the same results in column B, but without the day part of the date, leaving only the month and year so it looks like this:
Jan-05
All the information is in a uniform fashion, with 2 digits for the day, a dash, three letters for the month, a dash, and then 2 digits for the year.
I know this is basic stuff, but I am crap with excel, so I would greatly appreciate any help you can give me.
Thanks in advance!!