Pull Text from String using Delimiter


I would like to parse the text from a string in another cell. However, the string might not always be the same length so I cannot use LEFT or RIGHT.

Here are two examples of what the string might look like:



Both examples above have 5 numbers separated by commas. What would the formula be to always get the 3rd number (7 and 8 in the examples above)?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!