Answer the question
In order to leave comments, you need to log in
N
N
Nicholas the First2020-02-06 14:11:53
Nicholas the First, 2020-02-06 14:11:53
How to SPLIT rows in Google Sheets into one formula?
Google Sheets link
How to decompose a string into one formula?
Should be like in line #2
1 answer(s)
@ppcprofi
A
Alexander Ivanov, 2020-02-06 @ppcprofi
Use REGEXEXTRACT.
=REGEXEXTRACT(A2;"(?i)(.*?)(acc.*?)_(.*)")
For the entire array at once
=ARRAYFORMULA(REGEXEXTRACT(A2:A7;"(?i)(.*?)(acc.*?)_(.*)"))
Similar questions
V
Villert2022-03-09 11:06:56
Google Sheets - how to script a new sheet with a specific name (date)?
1Reply
V
S
I
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question