I have a cell with City, ST and Zip all in the same sell. I need to pull the state into a separate column so I can sort by state.
What is the formula to take state only. Example: I have Chicago, IL 12345 how can I pull IL out of this field?
Thank you.