How to extract specific text

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
-
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
-
@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
Categories
Check out the Formula Handbook template!