removing part of string

[ksnapp]

hi, i have a sting that looks like the 24 seconds I need the numbe
alone. I tried a replace with "" as the new text and excell stil
treats the result as text. Any ideas

 

[Norman Harker]

Hi ksnapp!

If it's at the end, you could use a helper column

=--LEFT(A1,LEN(A1)-1)

The -- at the front converts the string return to a number.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ron Rosenfeld]

hi, i have a sting that looks like the 24 seconds I need the number
alone. I tried a replace with "" as the new text and excell still
treats the result as text. Any ideas?

If it is always one or more numbers followed by a <space>, then

=--LEFT(A1,FIND(" ",A1))


--ron