| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding cells with numbers and text
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 |
|
#2
|
|||
|
|||
|
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" wrote: 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 |
|
#3
|
|||
|
|||
|
You could also use Data | Text to Columns
tj "EddieZ" wrote: 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 |
|
#4
|
|||
|
|||
|
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" wrote: 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 . |
|
#5
|
|||
|
|||
|
Even easier. Thanks!
-----Original Message----- You could also use Data | Text to Columns tj "EddieZ" wrote: 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel - numbers as text | New Users to Excel | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
Linear Mode
