Extract name from multiline mangled text string in Google Sheets

Question

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?

Answer 1

Use 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:

• https://regexone.com/
• http://www.regular-expressions.info/quickstart.html
• https://regex101.com/