Remove space and the letter after

Hi -

I have a column with a list of names. Some name has first name, a space then middle initial and some has only the first name. See below example.

I'm trying to work a formula that take only the first name without the middle initial. I tried this =LEFT([First Name]@row, FIND(" ", [First Name]@row) - 1), but it show #invalid value on the one without initial.

Is there a formula that works all?

Thanks in advance!

Find more posts tagged with

Formulas

Accepted answers

Mike Wilday

Yes, wrap your formula in an IFERROR formula. This should do the trick for you. If there is an error because there is no space, then it will just use the first name at row.

=IFERROR(LEFT([First Name]@row, FIND(" ", [First Name]@row) - 1), [First Name]@row

All comments

Mike Wilday

Yes, wrap your formula in an IFERROR formula. This should do the trick for you. If there is an error because there is no space, then it will just use the first name at row.

=IFERROR(LEFT([First Name]@row, FIND(" ", [First Name]@row) - 1), [First Name]@row

Zee Cheok

This is exactly what I'm looking for! THANK YOU!! 😀

Mike Wilday

You're welcome! :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.