jimbomcmucka
New Member
- Joined
- Oct 11, 2022
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
Hey guys,
I'm not sure what I am doing to hit difficulties with this.
I am trying to extract just the text in a string between the 5th and 10th occurrence of a "/". I have tried combining textbefore and textafter functions but am hitting a #VALUE! error each time. Below is my formula, what am I doing wrong?!
=TEXTBEFORE(TEXTAFTER(DATA!A2, "/",5), "/",10)
Thanks as always for your help!
Jim
I'm not sure what I am doing to hit difficulties with this.
I am trying to extract just the text in a string between the 5th and 10th occurrence of a "/". I have tried combining textbefore and textafter functions but am hitting a #VALUE! error each time. Below is my formula, what am I doing wrong?!
=TEXTBEFORE(TEXTAFTER(DATA!A2, "/",5), "/",10)
Thanks as always for your help!
Jim