Hi,
I have difficulty figuring this thing out :
let say I have a column name IDNumber and the first value is 810506-00W33466 :
| IDNumber |
810506-00W33466
The first six characters (810506) is a date of birth which is started by Year followed by Month and Day :
810506 = 6 May 1981
The problem is I need a formula that can automatically copied the first six characters into another column (let say DateOfBirth) as a date format. So it suppose to show like this :
| DateOfBirth |
06 May 1981
Hope anyone can help me on this one coz currently i’m dealing with a spreadsheets that contain more than 500,000+ rows of data! Thanks.
Bob
Kyoto Japan