lundi 23 février 2015

Insert characters into string in different locations

I have a string which looks like this 20141007023617. And I would like to make it look like this 2014-10-07T02:36:17Z. The T and Z are very important for me. So I would like to insert them as well.


So a recap,


A1 holds this string 20141007023617


B1 should hold this string 2014-10-07T02:36:17Z


Aucun commentaire:

Enregistrer un commentaire