
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 14, 2021 10:22 AM
Hello community,
I have a problem that is when I scan a barcode with my tablet the following characters are displayed like this:
0096
UNIT0855
121F21
I would like it to be displayed like this:
0096UNIT0855121F21
So I would like a formula that allows me to do this task automatically.
Could someone please help me?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 14, 2021 11:31 AM
Welcome to the Airtable community!
SUBSTITUTE({field name}, "\n", "")
You can see this and all the other formulas in the formula field reference.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 14, 2021 11:31 AM
Welcome to the Airtable community!
SUBSTITUTE({field name}, "\n", "")
You can see this and all the other formulas in the formula field reference.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 14, 2021 11:34 PM
Thank you it’s perfect ! Have a nice day !
