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.

Converting hyphen into sequential numbers

Topic Labels: Formulas
586 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AaronB
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey all! I have a problem that I hope you can help with. I have a massive amount of data that I need to put into Airtable that I received in the below format. However, I need to put each individual instance into a linked record field in AT, so the 1-5, will need to be 1, 2, 3, 4, 5. The amount of data I have will take me months to manually import one record at a time. 

I am hoping to create a formulate that will pull out the hyphenated numbers and return a value of GKM5L1, GKM5L2, GKM5L3... etc for the first line so that I can copy and paste values into AirTable instead of entering manually. 

Screen Shot 2024-03-19 at 3.39.58 PM.png

I would really appreciate any help! Thanks!

1 Reply 1
AaronB
5 - Automation Enthusiast
5 - Automation Enthusiast

I don't know if it is helpful, but I tried ChatGPT looking for an answer first, which gave me this response:

Screen Shot 2024-03-19 at 3.57.11 PM.png

Unfortunately, this doesn't work because there is no "Sequence" function.