Solved

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

Posted on 2011-03-17
2
212 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:jnbkze
2 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 125 total points
ID: 35160524
=VALUE(SUBSTITUTE(A1," ms",""))

Kevin
0
 
LVL 3

Author Closing Comment

by:jnbkze
ID: 35160578
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

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Outlook Free & Paid Tools
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now