CutString96_NumberX

Extract a full number from string block having 1 or more full numbers.
Like 1st number from ...
Authorized common shares 32,000; issued 10,711 and 10,556, respectively
32000
Or 2nd number 10711
Edit 2026-04-26: Adding StartFromChar to limit the search and cut starting from certain character
Edit 2024-12-04: Fixing how to handle the dot . and the comma, we are now including . in number, excluding ,

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net

FromString, Optional NumberOccurance = 1

CutString96_NumberX("Authorized common shares 32,000; issued 10,711 and 10,556, respectively", 3)

Returns 10556

Views 163

Downloads 30

CodeID

DB ID

VBA

Math

ANmarAmdeen
796

Attachments

Revisions

v3.0

Sunday

April

26

2026

Tags 9

number numeric return cut cutstring cutstring3 id html block

Needs 1

Codes Required 1

Similar codes

Recent 4 by ANmarAmdeen 4

Random Codes 4