<"1 Hour and 33 minutes" and want to convert that as well.

convert to what?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jamie" wrote in message ...
|I have data that is in a word document and it is written "37 Minutes". When
| i copy that data into a cell in excel I want it to just show "37". I have
| tried different formatiing option but to no avail. I also have a field
| written out "1 Hour and 33 minutes" and want to convert that as well.
|
| Any ideas?