separate strings

[laumartinezb]

Hello all!

I was trying to obtain the year and month from this: 1905

Year should be 2019 and month may.

Thank you very much in advance!

Laura

[lorenzoconforti · Accepted solution]

You could try this

=makedate(left([YourField],2)+2000, right([YourField],2))