Text to columns delimited by # character

rmillar

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

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.