Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Remove space from beginning of entries

Solved
Jump to Solution
5020 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Nolan_Morrow
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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.

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

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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.

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