
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 21, 2020 07:03 PM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 21, 2020 08:03 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 21, 2020 08:03 PM
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.
