2

I want to extract 2 from the string in cell C3 and return it as the result of the function in cell E3:

enter image description here

Probably SPLIT is the wrong approach here.

Edit:

I replaced the 2 with s because some approaches work for numbers but not for letters:

enter image description here

Improve this question

1 Answer 1

Reset to default
2

Try the following

=REGEXEXTRACT(A1,"\d")*1

enter image description here

Following OP's edit

=REGEXEXTRACT(A2,";(.*),")

enter image description here

Please read more about REGEXEXTRACT

Improve this answer
Sign up to request clarification or add additional context in comments.

5 Comments

Thank you, your approach seems to work for numbers but not for letters. The 2 is just a placeholder for any arbitrary text. I was hoping to find a way to extract text, not only numbers. Im gonna change my question.
It is numbers that you asked for. Please use more representative data.
I shouldv made that clear from the beginning. sorry, I need to extract words, not numbers
It works, thank you :-). Just a small addition: 1. I am using the european version of google sheets and 2. intern delimiter in my case was : not ; so the right formula for my case is: =REGEXEXTRACT(C3; ":(.*),")
Correct. It always depends on one's locale.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.