Gordon Hughes
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER