this post was submitted on 23 Aug 2023
3 points (100.0% liked)

Excel is Cool!

84 readers
6 users here now

Prove to the world Excel is cool!

founded 1 year ago
MODERATORS
[email protected]
3
How do I extract text between two of the same characters on a string, given that said character has appeared before? (lemmy.ml)
submitted 1 year ago by [email protected] to c/[email protected]
2 comments fedilink hide all child comments
 

I'm trying to extract the diameter here, so for example from the strings

1234-AB-001-4"-X01 and 1234-AB-002-1.1/2"-X01

how do I exctract the 4" and 1.1/2"?

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 2 points 1 year ago

It worked! Thanks so much, I was going crazy over this.