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

Home > Back-end > How can i get a sting from a cell within captions?

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

Time：10-04

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

Example:

Cell A1 contains "Dwayne 'TheRock' Johnson" and I'm trying to get a formula where Cell A2 gets "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'