Split cell

[Elton Law]

Dear Expert,
How to split a cell into 3 parts if they are like this please ?

Before:
9j36 in one cell
After:
9 j 36 in 3 different cells

Before:
10°32 in one cell
10 ° 32 in 3 different cells

Thanks

 

[Eduardo]

Hi,
use text to columns, fixed with, next and then click between the letters or
numbers where you want to create a column, next next

 

[Ron Rosenfeld]

Dear Expert,
How to split a cell into 3 parts if they are like this please ?

Before:
9j36 in one cell
After:
9 j 36 in 3 different cells

Before:
10°32 in one cell
10 ° 32 in 3 different cells

Thanks

Take a look at the responses to your original thread which you posted two
minutes before this one.
--ron