Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Writing a formular on taking first four numbers of another field

Topic Labels: Formulas
476 1
Showing results for 
Search instead for 
Did you mean: 


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.

1 Reply 1


In order to do that, you first need to ensure your field is defined as text (A) and not a number (#). That should be all.