Remove a character from a number field

T

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,
 
F

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
 
Top