Converting hyphen into sequential numbers

Topic Labels: Formulas
177 1
Showing results for 
Search instead for 
Did you mean: 
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
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.