Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =ARRAYFORMULA(
- IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)02")))=18,
- REGEXEXTRACT(A2:A&"", "00(.*)02"),
- IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)02")))=18,
- REGEXEXTRACT(B2:B&"", "00(.*)02"),
- IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)02")))=18,
- REGEXEXTRACT(C2:C&"", "00(.*)02"),
- IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)15")))=18,
- REGEXEXTRACT(A2:A&"", "00(.*)15"),
- IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)15")))=18,
- REGEXEXTRACT(B2:B&"", "00(.*)15"),
- IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)15")))=18,
- REGEXEXTRACT(C2:C&"", "00(.*)15"),
- IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)10")))=18,
- REGEXEXTRACT(A2:A&"", "00(.*)10"),
- IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)10")))=18,
- REGEXEXTRACT(B2:B&"", "00(.*)10"),
- IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)10")))=18,
- REGEXEXTRACT(C2:C&"", "00(.*)10"),
- IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)11")))=18,
- REGEXEXTRACT(A2:A&"", "00(.*)11"),
- IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)11")))=18,
- REGEXEXTRACT(B2:B&"", "00(.*)11"),
- IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)11")))=18,
- REGEXEXTRACT(C2:C&"", "00(.*)11"),
- IF(LEN(IFERROR(REGEXEXTRACT(A2:A&"", "00(.*)")))=18,
- REGEXEXTRACT(A2:A&"", "00(.*)"),
- IF(LEN(IFERROR(REGEXEXTRACT(B2:B&"", "00(.*)")))=18,
- REGEXEXTRACT(B2:B&"", "00(.*)"),
- IF(LEN(IFERROR(REGEXEXTRACT(C2:C&"", "00(.*)")))=18,
- REGEXEXTRACT(C2:C&"", "00(.*)"), ))))))))))))))))
- =ARRAYFORMULA(IFERROR(
- IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(
- IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(
- REGEXEXTRACT(A2:A&"", "00(d{18})02"),
- REGEXEXTRACT(B2:B&"", "00(d{18})02")),
- REGEXEXTRACT(C2:C&"", "00(d{18})02")),
- REGEXEXTRACT(A2:A&"", "00(d{18})15")),
- REGEXEXTRACT(B2:B&"", "00(d{18})15")),
- REGEXEXTRACT(C2:C&"", "00(d{18})15")),
- REGEXEXTRACT(A2:A&"", "00(d{18})10")),
- REGEXEXTRACT(B2:B&"", "00(d{18})10")),
- REGEXEXTRACT(C2:C&"", "00(d{18})10")),
- REGEXEXTRACT(A2:A&"", "00(d{18})11")),
- REGEXEXTRACT(B2:B&"", "00(d{18})11")),
- REGEXEXTRACT(C2:C&"", "00(d{18})11")),
- REGEXEXTRACT(C2:C&"", "00(d{18})")),
- REGEXEXTRACT(B2:B&"", "00(d{18})")),
- REGEXEXTRACT(A2:A&"", "00(d{18})"))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement