I need to extract the word Trilocale from a complex multiline text like this in a google sheets cell (including n)
<code>1/19 vetrina
199.000
Trilocale via Arnoldo Mondadori 89, Borgo Venezia, Verona
</code>
<code>1/19 vetrina
199.000
Trilocale via Arnoldo Mondadori 89, Borgo Venezia, Verona
</code>
1/19 vetrina
199.000
Trilocale via Arnoldo Mondadori 89, Borgo Venezia, Verona
Tried
<code>=regexextract(A18;"^.+n.+n.+n(.*)")
</code>
<code>=regexextract(A18;"^.+n.+n.+n(.*)")
</code>
=regexextract(A18;"^.+n.+n.+n(.*)")
but giving me the whole third line. I only need the first word after the third n PLease help! thanks, Alex
New contributor
Dr. Ziller is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
0
You can use:
<code>=REGEXEXTRACT(A1,"^.+n.+n(.+?) ")
</code>
<code>=REGEXEXTRACT(A1,"^.+n.+n(.+?) ")
</code>
=REGEXEXTRACT(A1,"^.+n.+n(.+?) ")
Another solution that doesn’t use regex:
<code>=+SPLIT(INDEX(SPLIT(A1,"
"),3)," ")
</code>
<code>=+SPLIT(INDEX(SPLIT(A1,"
"),3)," ")
</code>
=+SPLIT(INDEX(SPLIT(A1,"
"),3)," ")