Convert String to Numeric Values

J

JenISCM

I have data string that I must convert to numeric values.

Ex:
00100200300400500600700800901000110015016

How do I get the above data string example to return the numeric values that
are three digit integers.

How do I get the number 16 for example?

Any assistance is appreciated
 
J

John W. Vinson

I have data string that I must convert to numeric values.

Ex:
00100200300400500600700800901000110015016

How do I get the above data string example to return the numeric values that
are three digit integers.

How do I get the number 16 for example?

Any assistance is appreciated
Click to expand...

How long is a string? will it always be 48 characters long, or is it variable?

Val(Mid([string], 3*([Which number:] - 1), 3))

will prompt you for which substring you want and return the value in that
substring, if that helps you.

John W. Vinson [MVP]
 
Top