Untitled
unknown
plain_text
a year ago
133 B
3
Indexable
=iferror(if(Right(Left(U4,4), 3)=$B$2, CONCATENATE("-", index(split(U4, " "), 0, 3)), CONCATENATE("-", index(split(T4, " "), 0, 3))))
Editor is loading...
Leave a Comment
=iferror(if(Right(Left(U4,4), 3)=$B$2, CONCATENATE("-", index(split(U4, " "), 0, 3)), CONCATENATE("-", index(split(T4, " "), 0, 3))))