How parse out characters from long string?

  • Thread starter Thread starter Chet
  • Start date Start date
C

Chet

Am having problems parsing out characters from a long string I have
many rows of. The data looks like 215781507021 and the problem is that
the Excel keeps converting the data to the scientific notation format
(example 2.15782E+11) when I use the mid( ) function to take the
selected characters that I want. What am I doing wrong? I even tried
using the cstr() command to change the format to 'text' but I still
keep getting just the n-th characters from the scientific notation
version of the number.

Thanks,
Chet
 
Use the Format function to get the correct numeric string, then
use your Mid command on that. E.g.,

Debug.Print Mid(Format(Range("A1"), "0"), 1, 4)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top