Remove space from beginning of entries

Nolan_Morrow · ‎Apr 21, 2020

Hello,

I have a contacts record with peoples first and last names and for some reason many of them (not all) were imported with a space before their name. Is there a way to remove this space for each record? Thanks in advance!

kuovonne · ‎Apr 21, 2020

Welcome to the Airtable community!

You can use the TRIM() function in a formula field to remove white space. It is documented in the formula field reference.

For example, suppose you have the field {first name} and some of the names start with a space.

Create a new formula field with the function TRIM({first name}).
If there are a lot of names, wait for Airtable to populate the values for the entire column.
Copy the entire column of trimmed names from the formula field to the original {first name} field.

See Solution in Thread

kuovonne · ‎Apr 21, 2020

Welcome to the Airtable community!

You can use the TRIM() function in a formula field to remove white space. It is documented in the formula field reference.

For example, suppose you have the field {first name} and some of the names start with a space.

Create a new formula field with the function TRIM({first name}).
If there are a lot of names, wait for Airtable to populate the values for the entire column.
Copy the entire column of trimmed names from the formula field to the original {first name} field.