HELP!!!!! (apo on worksheet functions)

D

DestinySky

I am working on a spreadsheet and when you "look" at the cell it looks like
this:
'S000000200BX00000001000 . I need to figure out how to do an auto sum on
these. I was messing around and did a few find and replace and got rid of the
'S thing and now I have a formula that looks like this... 2E+13... what is
going on with this crazy thing?? This is a spreadsheet that is not made with
in my company and I am not sure of how it was created!

ANY HELP IS GREATLY APPRECIATED!!! PLEASE!!!!!!!!
 
D

DestinySky

So do I enter this into each cell? This sheet contains about 2000 rows that
need to be changed. Not all of them are "200" some are 1200, 2400, 800, and
so on.
What exactly dd they do? What does this MID function do?

You are a great help!! Thank you so much for your time!!!
 
D

Don Guillett

This formula will do it. Just make sure have data in the range
=SUMPRODUCT(--(MID(C3:C6,3,FIND("BX",C3:C6)-3)))
Look in help index for MID to find out more about MID
 
Top