Hi Elton,

Try Data - Text to columns.

--
Regards,

OssieMac


"Elton Law" wrote:

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

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

Befo
10°32 in one cell
10 ° 32 in 3 different cells

Thanks