removing part of string

  • Thread starter Thread starter ksnapp
  • Start date Start date
K

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
 
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.
 
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?
Click to expand...

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

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


--ron
 
Back
Top