[SOLVED] How parse out characters from long string?

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


"Chet" <chetshannon@gmail.com> wrote in message
news:1138052783.370153.288230@g14g2000cwa.googlegroups.com...
> 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
>

Thanks very much !.... Chet