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