Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Extract Decimal Value from String in Excel
This tutorial will show you how to extract particular decimal values that are embedded within text strings in Microsoft Excel. It can be difficult to work with data that combines language and numbers, especially when you need to separate and extract particular numerical figures for additional research or calculations. Excel has a number of strong features and methods that can help you complete this task quickly.
Learning how to extract decimal values from strings will greatly improve your data manipulation abilities in Excel, whether you're working with financial data, product codes, or any other language that contains numeric information. You'll have a firm grasp of the methods and functions required to efficiently extract decimal values from strings in Excel by the end of this tutorial. Let's get started and utilise Excel's full potential to retrieve those elusive decimal numbers!
Extracting Decimal Value from String
Here, we will first create a VBA module and then run it to complete the task. So let us see a simple process to learn how you can extract decimal values from strings in Excel.
Step 1 : Consider an Excel sheet where you have a list of decimal strings similar to the below image.
First, use Alt + F11 to open the VBA application.
Step 2 :Then click on Insert, select Module, and copy the below code into the textbox.
Insert > Module > Copy.
Sub GetNumber()
Dim xSRg As Range
Dim xDRg As Range
Dim xPRg As Range
Dim xSRgArea As Range
Dim xRgVal As String
Dim xAddress As String
Dim I As Long
Dim K As Long
Dim KK As Long
On Error Resume Next
xAddress = Application.ActiveWindow.RangeSelection.Address
Set xSRg = Application.InputBox("Please select range:", "Extract Decimal Value", xAddress, , , , , 8)
If xSRg Is Nothing Then Exit Sub
Set xDRg = Application.InputBox("Select single cell:", "Extract Decimal Value", , , , , , 8)
If xDRg Is Nothing Then Exit Sub
Set xDRg = xDRg(1)
For I = 1 To xSRg.Areas.Count
Set xSRgArea = xSRg.Areas.Item(I)
For K = 1 To xSRgArea.Count
xRgVal = xSRgArea(K).Value
KK = xSRgArea(K).Row - xSRg.Row
If IsNumeric(xRgVal) Then
xDRg.Offset(KK) = xRgVal - VBA.Fix(xRgVal)
End If
Next
Next
End Sub
Step 3 :Then click F5 to run the module, select the range of cells containing the strings, and click Ok.
Step 4 :Then select a single cell where you need to place the result and click OK.
Conclusion
In this tutorial, we have used a simple example to demonstrate how you can extract decimal values from strings in Excel to highlight a particular set of data.
157 Views
