itsgrady
Board Regular
- Joined
- Sep 11, 2022
- Messages
- 116
- Office Version
- 2021
- Platform
- Windows
- MacOS
I need to pull the text nested between the 5th and 6th "/" in a long string of text, I tried the following formula:
=MID(A1, FIND("/", A1, FIND("/", A1, FIND("/", A1, FIND("/", A1) + 1) + 1) + 1) + 1, FIND("/", A1, FIND("/", A1, FIND("/", A1, FIND("/", A1, FIND("/", A1) + 1) + 1) + 1) + 1) + 1) - FIND("/", A1, FIND("/", A1, FIND("/", A1) + 1) + 1) - 1)
It is not pulling the portion of the text I need. Is there a simpler formula?
Thanks for any help.
=MID(A1, FIND("/", A1, FIND("/", A1, FIND("/", A1, FIND("/", A1) + 1) + 1) + 1) + 1, FIND("/", A1, FIND("/", A1, FIND("/", A1, FIND("/", A1, FIND("/", A1) + 1) + 1) + 1) + 1) + 1) - FIND("/", A1, FIND("/", A1, FIND("/", A1) + 1) + 1) - 1)
It is not pulling the portion of the text I need. Is there a simpler formula?
Thanks for any help.