How can i get a sting from a cell within captations?-CodePudding

Home > front end > How can i get a sting from a cell within captations?

How can i get a sting from a cell within captations?

Time：10-03

Is it possible to get the text between two captations in a cell?

example:

Cell A1 Contains Dwayne 'TheRock' Johnson and i'm tryging to get a formula where Cell A2 get's TheRock from cell A1

So i can get just the nickname of the people listed that are always within ''.

CodePudding user response：

use this

=REGEXEXTRACT(A1,"\'.*\'")

result

A1=Dwayne 'TheRock' Johnson

A2='TheRock'