Delete line break

[Joannis_Tom]

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?

[kuovonne · Accepted solution]

Welcome to the Airtable community!

SUBSTITUTE({field name}, "\n", "")

You can see this and all the other formulas in the formula field reference.

[Joannis_Tom]

Thank you it’s perfect ! Have a nice day !