Code for Eliminating Letters In The Same Cell as a Number

[Guzzlr]

Hello All...
I have a little problem here.
I have a MS Project File, which inputs an entered number with "hrs" for hours. For example, If I enter 36 into the Project file cell, Project enters the number as: 36hrs.

The problem is if I copy and paste 36hrs into excel, I can't run compute with excel because it will not recognize 36hrs as 36. Is there code which will search column "C:C" to eliminate all the cells (within that column) to change the "hrs" numbered format to just a number?

Thanks for the help
excel 2013

 

[Joe4]

No code needed for this.
If you select the column, and then do a Find/Replace, replacing "hrs" with nothing, it will remove all the "hrs" bits, and the rest will be changed to numbers.

If you want VBA code (because it is part of a larger process), simply turn on the Macro Recorder as you record the steps above, and you will have VBA code that does that.

 

[Guzzlr]

Got It...Keep Forgetting about the recorder
Thank you