I know the start point from the right
I have a numerical value I need to sort out. They are dates that have come from another database, and they end up in my Excel file looking like 1052008 or 11052008. All the years have four digits, all the days have two digits, but some of the months have one digit and some of the months have two digits. I can get the year out alright with =RIGHT(A1,4), but I'm having trouble getting the month and the day out properly. Any suggestions?
Keep Up with TechRepublic