Remove a character from a number field

[Taj]

I’m working with a column of various hh:mm data. Example of data:

29.28h
344.25h
26.75h
7.25h
0h
12.5h
0h
14.5h
13.25h

As you can see, there is no fixed decimal place. Does any one know how I may
be able to move the ‘h’ from the end of the numbers for the column?

Thanks in advance,

 

[Mike H]

Try this and drag down

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

Mike

 

[FSt1]

hi
the simplest and easiest way might be to use find and replace.
high light the column then ctrl+F
click the replace tab
find what:= h
replace with:= leave blank
click replace all

regards
FSt1

 

[David Biddulph]

Edit/ replace/ h/ with /(nothing)

 

[Taj]

Hey thanks guys, you've saved me a great deal of time