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!!
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

MOB

Well-known Member
Joined
Oct 18, 2005
Messages
1,042
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,042
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,545
Messages
5,832,387
Members
430,129
Latest member
EmilyCrandall

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top