I'm trying to break this data up into two columns that I can subtract from each other. So for example I'd like to change 1950/ 50 to 1950 - 1950 = 0
The problem is sometimes the number on the right of the / only has two digets. So for example 1940/60 should be 1940/1960.
I first seperated the number into two columns based on the / using split column button.
Next I'd like to create some logic that says if there are less than 4 characters in Face1.2, append the left two characters from Face1.1 to Face1.2. I'm having trouble doing this. I tried using the prefix option to do this and changed the face to LEFT([Face1.1],2) but I got an error.
Thanks for the help!