Help

Auto-filling cells with information from other cells

Solved
Jump to Solution
1063 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Sandoval
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello all,
I have a table with filled with products each with their respective item numbers that are 24 characters long. I am looking for a way to put in the 24 digit number and have it automatically fill a separate cell in the line with the last four digits of that number. I need two columns one with the full 24 digit number and one with just the last four. I’m currently just manually entering them separately. TIA

EDIT: Fount the solution https:// community.airtable .com /t/formula-for-extracting-last-text-digits-from-a-code/23215

1 Solution

Accepted Solutions
Daniel_Sandoval
5 - Automation Enthusiast
5 - Automation Enthusiast

I found the solution in another topic! https:// community.airtable .com /t/formula-for-extracting-last-text-digits-from-a-code/23215

See Solution in Thread

1 Reply 1
Daniel_Sandoval
5 - Automation Enthusiast
5 - Automation Enthusiast

I found the solution in another topic! https:// community.airtable .com /t/formula-for-extracting-last-text-digits-from-a-code/23215