Pull Text from String using Delimiter

Options

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:

1,5,7,33,15

13,22,8,1,16

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)?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!