Delete a letter next to a number

  • Thread starter Thread starter jzis
  • Start date Start date
J

jzis

How can I remove a letter that is next to a number?

Find/replace does not work.

I cut and paste figures from MS Project to Excel. This is
how the information appears in excel after pasting.

167.68h 98.28h 173h

How can I remove the letter h from each of the cells,
without going into every one? It is extremely time
consuming to do this.

Thank you.


- - - jzis
 
Why doesn't Find/Replace work? What message do you get? Have you set the
options so that it *doesn't* look for an exact match in the cells?
 
Why does find/replace not work?

You can try SUBSTITUTE(A1,"h","") if you want a formula.
 
Back
Top