If I find that I have a single cell with values delimited with | , how
could I split each value into new cells across columns

so

YES|NO|MAYBE in A1 would be "YES" in C1, "NO" in D1, "MAYBE" in E1
NO in A2 would be "NO" in C2
YES|NO|MAYBE|ALWAYS in A3 would be "YES" in C3, "NO" in D3, "MAYBE" in
E3