I am using importhtml()
to read data from a website and end up with a value like this in cell A1:
1
JorgeJ SolerSoler
DH
1
How do I extract the name "Jorge Soler" from this data?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityUse a formula like this:
=regexextract(A1, "[A-Z][a-z]+") & regexextract(A1, "( [A-Z][a-z]+)[^ ]*?$")
To learn the exact regular expression syntax used by Google Sheets, see RE2. These sites may also help: