Seperate values in an Excel cell

I have cell with the following value
1.87/1
13.29/1
0.76/1
1.37/1
1.47/1

I would like to extract this into 2 cells as shown below the / is the character which seperates the value
1.87    1
13.29  1
0.76    1
Gordon HughesDirectorAsked:
Who is Participating?
 
AnuroopsunddCommented:
select the column
Click on data at the top
Click on "Text to Column"
click next
click other and in text box put /
click finish
0
 
Gordon HughesDirectorAuthor Commented:
Good solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.