Automate Split Text to Columns, after row creation from form.
I am creating a sheet for the purpose of inventory. On our items being inventoried they have a QR code that generated txt info. I want to split the txt into several separate columns.
Example of what is generated:
Model Number: AS3100
Size: L
Lot # 204186
Serial # 27233412
Level: IIIA
D.O.M. 06/2020
I want to autofill 6 different columns with only the individual info not the description of the info. Example:
In the Model Number column I want it to read AS3100
Thank you
Answers

Hey @Ripj
Is the format of the output in the cell identical to what you displayed? Line breaks are between each bit of information? A screenshot is always helpful.
If this is exact, try these:
Model Number
=MID([QR Code Field]@row, FIND(":", [QR Code Field]@row) + 1, FIND(CHAR(10), [QR Code Field]@row)  FIND(":", [QR Code Field]@row))@Ripj
Size
=MID([QR Code Field]@row, FIND("~", SUBSTITUTE([QR Code Field]@row, ":", "~", 2)), FIND("~", SUBSTITUTE([QR Code Field]@row, CHAR(10), "~", 3))  FIND("~", SUBSTITUTE([QR Code Field]@row, ":", "~", 2)))
Lot#
=MID([QR Code Field]@row, FIND("~", SUBSTITUTE([QR Code Field]@row, CHAR(35), "~", 1)) + 1, FIND("~", SUBSTITUTE([QR Code Field]@row, CHAR(10), "~", 6))  FIND("~", SUBSTITUTE([QR Code Field]@row, CHAR(35), "~", 1)))
Serial#
=MID([QR Code Field]@row, FIND("~", SUBSTITUTE([QR Code Field]@row, CHAR(35), "~", 2)) + 1, FIND("~", SUBSTITUTE([QR Code Field]@row, CHAR(10), "~", 7))  FIND("~", SUBSTITUTE([QR Code Field]@row, CHAR(35), "~", 2)))
Level
=MID([QR Code Field]@row, FIND("~", SUBSTITUTE([QR Code Field]@row, ":", "~", 3)), FIND("~", SUBSTITUTE([QR Code Field]@row, CHAR(10), "~", 9))  FIND("~", SUBSTITUTE([QR Code Field]@row, ":", "~", 3)))
D.O.M.
=RIGHT([QR Code Field]@row, 7)
Do these work for you?
Kelly
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!