Hello,
I'm looking for a formula that will allow me to split text into 4 rows, text is always in A1 in the format "1/1/1/1" but the numbers could be any length. I've tried righ and left but where the number lengths change it doesn't work for me.
I'm looking for a formula that will allow me to split text into 4 rows, text is always in A1 in the format "1/1/1/1" but the numbers could be any length. I've tried righ and left but where the number lengths change it doesn't work for me.