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
Post a Comment