Untitled
Anonymous
plain_text
07/08/2024 4:21 PM
180 B
17
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))))