Hello,

Sorry for the novice question but i was wondering on how to take the first four numbers from a field of numbers itself. I did try the LEFT formula but it doesnt seem to work for me.

Now, there is a field called Ticket with a string of about 10 numbers with the first four numbers being the year. I want to take those four numbers from that field and put them in another field.