How do I convert a cell that has a value with its unit of measure to a number only

I have a field that has a number with it's unit. In this case it happens to be ping times so the value in the cell is "89 ms"

How do I convert "89 ms" to be a real number with a value of "89"

I know thise should be dead simple, but I'm not a VBA guy, and I cant find a built in function to do this.

I'm using Excel 2010

Thank you.
LVL 3
jnbkzeAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
=VALUE(SUBSTITUTE(A1," ms",""))

Kevin
0
 
jnbkzeAuthor Commented:
Perfect. I'm sure there's tons of ways to do this, but your solution worked exactly as I needed it to. Thank you.
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.