Left/Right Functions

[chet645]

I have a bunch of dates that that are formatted as:

1252011
1112011
12302010
12152010
11162010
etc.

the month is first one or two digits, with the date (2 digits) and year following (4 digits). I want to use the right/left function to strip the month out of the data. The problems is the month can either be the first 1 or 2 characters depending on the month. Any suggestions would be greatly appreciated.

Thanks.

Chet

 

[Jonmo1]

So long as the Day is always 2 digits, and year is always 4 digits...
Try

=LEFT(A1,LEN(A1)-6)

 

[Smitty]

Welcome to the Board!

I'd try Data-->Text to Columns. If you skip the first two options, on the third tab there's a date conversion option. It should work for all of the valid dates in your list.

HTH,