troubleshooting Question

Strip data in string in column

Avatar of Richard Kreidl
Richard KreidlFlag for United States of America asked on
Microsoft Excel
8 Comments1 Solution378 ViewsLast Modified:
I have the following data in  column B. I need the string of data to be stripped and only have the month and year within the cell in the same column.

Thu Oct 28 23:00:12 2013
Thu Nov 28 23:15:05 2013
Thu Oct 28 23:00:04 2013
Thu Dec 28 10:02:26 2013
Thu Dec 28 19:39:00 2013
Thu Oct 28 22:15:11 2013
Fri Nov 1 06:01:28 2013
Thu Aug 28 19:13:14 2013
Fri Aug 1 03:04:59 2013

It should look like this;
Oct 2013
Nov 2013
Oct 2013
Dec 2013
Dec 2013
Oct 2013
Nov 2013
Aug 2013

I got this VBA Macro from an earlier EE posting thats just strips off the month, but I would now like the month and year:

Sub doMacro()

Dim DataRange As Range, C As Range
Set DataRange = Range("A1:A16")

   For Each C In DataRange
         Cells(C.Row, 2) = Split(C.Value, " ")(1)
   Next C

End Sub

Saqib Husain

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros