Jump to content
Sign in to follow this  

How to remove the last word in a field?

Recommended Posts


I have an old address book (.cwk) that clumped the first and last name together. I am hoping to create a new field that trims the last word off of text value in this field so I'm left with everything but the last name. I've tried a few calcs but I can't seem to get this working.

Share this post

Link to post
Share on other sites


LeftWords ( FullName ; WordCount ( FullName ) - 1 )

Note that some last names can be two or more words.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.