Excel UDF Get Numbers from Text

Excel UDF | Get Numbers From Text

Excel

We will be going to see the new user-defined Excel Functions (UDF). This Function can retrieve Numbers from Text String.

Most of the time we required number values from text strings, In that case this function is most useful.

What is name of this Function ?

This functions name is = NumFromTxt_UDF(Cell_reference).

Does this function exist in Excel?

No, this function does not exist in Excel. This is a Customized Function. Follow below given steps to add this function.

What are the inputs, we have to provide to get the Result?

  • Cell_Reference = Cell where Text String contains Number.

How to use these new UDF Functions?

  1. Just Type Function Name – NumFromTxt_UDF( ) and
  2. Provided cell reference inside bracket,
  3. Done ! It will find numbers.

If text contains Multiple Numbers Separated by Text or spaces, It will show all numbers with “|” Separator.

See Example Below

Step-1 Insert Function – NumFromTxt_UDF( )

Step_1

Result in each Case.

Step_2

In which case we can use this function ?

We can use this function –

– To get dates from Prepaid expenses Narration from Accounting entry.

– To get Amounts from any text string of any report (like, disclosure part of any Notes to financial statements).

How to add this Functions to Excel?

Follow the steps below to activate these functions –

Go to “File”>> “Options” >> “add-ins” Option >> Select “Excel Add-ins” & Click “Go” >> click “Browse” >> Copy in add-ins in the Window. >> Click “OK” >> Tick Mark New Add-ins Name >> It’s Done.  

Now This function will be Activated for All Excel Workbook.

Which Add-ins Need to be added to Activate Functions? (Download Link)

Free Download Link is provided for Add-ins (Sum by Color). 

Download Below Add-ins to activate Functions.


Download (NumFromTxt_UDF)

Your Suggestions for future development are always welcome, Feel free to write in Comment below.

Leave a Reply

Your email address will not be published. Required fields are marked *