Split Text in a Cell (4 columns)
 

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

Split Text in a Cell (4 columns)
 

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?

--
Rick (MVP - Excel)


"Elton Law" wrote in message
...
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