Adding cells with numbers and text

[EddieZ]

I have a series of cells with mileage such as "1.02 mi".
I'd like to add the mileages without having to delete
the "mi". Is that possible?

Thank You!

EZ

 

[Guest]

This seems to do what you are asking, provided there is a space between the
end of the number and the beginning of the text.
=SUM(LEFT(A1,FIND(" ",A1,1)))

tj

 

[Guest]

You could also use Data | Text to Columns

tj

 

[EddieZ]

Perfect. Thank You!

EZ

-----Original Message-----
This seems to do what you are asking, provided there is a space between the
end of the number and the beginning of the text.
=SUM(LEFT(A1,FIND(" ",A1,1)))

tj


.

 

[EddieZ]

Even easier. Thanks!

-----Original Message-----
You could also use Data | Text to Columns

tj


.