Extracting data

[Ruzzo]

If I have a cell that contains the following:

A.00052536

What is the formula to extract the first 5 characters, so I'm left with 52536.

thanks in advance

Ruzzo

 

[Trouttrap2]

Try

=REPLACE(A1,1,5,"")

 

[Rick Rothstein]

Is your text always ten characters long? If so...

=RIGHT(A1,5)

 

[Ruzzo]

Yes, always 10 characters...this works. thanks

Ruzzo

 

[snoopyhr]

the right function returns the numeric data as text to convert to number use either of the following

=right(a1,5)+0
or
=right(a1,5)*1
or
=--right(a1,5)

 

[Rick Rothstein]

the right function returns the numeric data as text to convert to number use either of the following

I returned it as text on purpose, just in case there were leading zeroes... you procedure would remove any leading zeroes. Of course, the OP didn't say exactly what he wanted, so we will have to wait for him to respond.