How to extract specific text

D Nyman
D Nyman โœญโœญโœญ

What formula would I use to copy the bolded text below from one column and insert it in another column. I would like it to happen automatically as new rows are added as well.

(04/22/2025) JB0002191706 POST sale walkout survey requested; lit building (04/22/2025) Waiting on survey response

Answers

  • DKazatsky2
    DKazatsky2 Community Champion

    Hi @D Nyman,

    Will the text always be exactly as you have above? Meaning the section you are after is always 12 characters long and follows the date? If so, the following will work.

    =MID([Column Name]@row, FIND(")", [Column Name]@row) + 2, 12)

    Hope this helps,

    Dave

  • prime_nathaniel
    prime_nathaniel โœญโœญโœญโœญโœญ

    @D Nyman assuming your format is consistent, you would use find on ") " that will get you the start of the string you want. You can then find "POST" to get the end of your string OR you can right substring to start at JB00 and then do a second search for the first " ". Either way that get's you your first and last characters. You can then just use LEFT and RIGHT to trim it out.

    Principal Consultant | System Integrations

    Prime Consulting Group

    Email: info@primeconsulting.com

    Follow us on LinkedIn!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!