Split Text in a Cell (4 columns)

[Elton Law]

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

 

[Rick Rothstein]

Is your text value **always** two digits followed by the ° symbol followed
by two letters followed by two digits followed by the apostrophe symbol
followed by two letters?

Also, are you looking for a VB or Excel formula solution?