Split cell

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

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
 
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
 
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
Click to expand...

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