Split Text in a Cell (4 columns)

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
 
R

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top