google docs - How to retrieve last string of a cell delimited by a special string -


how can value 1 , value 2 , value 3 following rows (cells) in google docs?

xyz1 --> xyz2 --> value 1                    xyz3 --> xyz4 --> xyz5 --> value 2           xyz6 --> value 3                             

does formula work want if example values in column a:

=arrayformula(iferror(right(a:a,len(a:a)-search("|",substitute(a:a,"-->","|",(len(a:a)-len(substitute(a:a,"-->","")))/len("-->")))-len("-->"))))


Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -