Dear Expert,

I have asked similar question before.
But I asked to split into 3 columns.

Now is it possible to split into 4 columns please?

First column is the text before °
Second column is the text after ° but before the numerical figure
Third column is the text before '
Forth column is the text after '

Say for an example ...
In a cell has the info like this ...

07°Pi25'Rx

4 columns should be split into these.

07
°Pi
25
'Rx

Thanks so much for help