ExcelBanter - EXTRACT NUMBER FROM STRING

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - EXTRACT NUMBER FROM STRING (https://www.excelbanter.com/charts-charting-excel/237674-extract-number-string.html)

aRJUN SINGH RAWAT SINGH SRAWAT TATDT

EXTRACT NUMBER FROM STRING

HOW TO EXTRACT NO FROM STRING SUCH AS
i M AGE OF 16
MY REF NO 2165 IS DISBURSED.

Héctor Miguel

EXTRACT NUMBER FROM STRING

hi, !

HOW TO EXTRACT NO FROM STRING SUCH AS
i M AGE OF 16
MY REF NO 2165 IS DISBURSED.

see the "ExtractDigits" section of this page:
http://www.mvps.org/dmcritchie/excel...gs.htm#related

regards,
hector.

All times are GMT +1. The time now is 01:15 AM.