
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 23, 2021 02:32 PM
Hello, this is an example of a value in my NAME field:
1290 Name 3 (Some Words)
1255 Another Name 12 (more words)
I’m looking for a formula that will get rid of the numbers and space before Name, and anything in parentheses) so would result in:
Name
Another Name
Thanks for any help!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 23, 2021 04:23 PM
This was as close as I got. Removes all whitespace though.
REGEX_REPLACE(Name,"(\\(.*\\))|(\\d)|(\\s)","")
EDIT: Or this. Leaves whitespace, which aren’t visable in Airtable.
REGEX_REPLACE(Name,"(\\(.*\\))|(\\d)","")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 23, 2021 04:23 PM
This was as close as I got. Removes all whitespace though.
REGEX_REPLACE(Name,"(\\(.*\\))|(\\d)|(\\s)","")
EDIT: Or this. Leaves whitespace, which aren’t visable in Airtable.
REGEX_REPLACE(Name,"(\\(.*\\))|(\\d)","")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 27, 2021 08:36 AM
Thanks, this seems to work!
