Text to columns delimited by # character

Hi, I have a column I need to separate from 1 column into 2, delimited by the # character. The output (new column) is consistently 6 characters, but the amount of characters preceding the # always varies. I know how to do this in Excel but would love do this with a formula in Smartsheet. Thanks for any tips in advance!

Example cell data

Column 1: Joe Drives A Slow Car #123456 needs to become

Column 1: Joe Drives A Slow Car

Column 2: 123456

Find more posts tagged with

Formulas

Accepted answers

All comments

Brandon R.

Looking over the functions list on our Help and Learning center (https://help.smartsheet.com/functions) I see a couple that might work for you.

https://help.smartsheet.com/function/mid

https://help.smartsheet.com/function/find

These are the two that appear to be the closest to what you're looking to do.

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.