Please Help me to delete part of the contents of a cells

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. :oops: :oops:

Thanks in advance!!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

MOB

Well-known Member
Joined
Oct 18, 2005
Messages
1,031
Office Version
  1. 365
Platform
  1. Windows
You can put a formula in column B "=A1" etc etc

And then format column B to show only the month and year
 

MOB

Well-known Member
Joined
Oct 18, 2005
Messages
1,031
Office Version
  1. 365
Platform
  1. Windows
Same answer, he explained it better :LOL:
 

thekingoflondon

Board Regular
Joined
Sep 22, 2005
Messages
67
excellent... cheers for that...

If, for example, I had a similar predicament with something that excel could not automatically format, such as a list of currencies, how would I go about eliminating part of a cell, so in column A if it said:

USD 300

I seperate this data out so that it would be just

300

in Column B
 

Watch MrExcel Video

Forum statistics

Threads
1,119,271
Messages
5,577,124
Members
412,769
Latest member
VK12345
Top