I came up with:
Code:Function F_snb(c00) F_snb = Split(c00, ">")(0) & ">" & Replace(Filter(Split(Replace(Replace(c00, ">", "/"), ";", "~/"), "/"), "~")(0), "~", "") End Function
I came up with:
Code:Function F_snb(c00) F_snb = Split(c00, ">")(0) & ">" & Replace(Filter(Split(Replace(Replace(c00, ">", "/"), ";", "~/"), "/"), "~")(0), "~", "") End Function
Last edited by snb; 09-10-2014 at 12:16 PM.
Bookmarks