Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

UPPER Formula First 3 Characters

Topic Labels: Formulas
2380 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ed_Brooks
5 - Automation Enthusiast
5 - Automation Enthusiast

I am new to Airtable and trying to uppercase only 3 characters of Company Name

UPPER(Company Name,3) & RECORD_ID()
(The whole company name is uppercase)

2 Replies 2
Julian_Kirkness
10 - Mercury
10 - Mercury

It would be something like this

UPPER(LEFT({Company Name},3)) & RECORD_ID()

Hope this helps!

Julian

Ed_Brooks
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much, this is exactly what I was looking to do! I look forward to learning more so I can contribute to the community.