E
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
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