How to Substitute a Singular/Plural word to nothing in an Alphanumeric Text..?
I have a certain formula in which I have to Replace/Substitue same words but they occur in singular or plurals then how can that be done by using wild characters?
Lets say I have a cell A1= 1 Hour or 2 Hours or 1 Day or 2 Days..
I need to convert this text into minutes 1.e. 1 Hour would be 60,120 but if its 1 Day then 24*60 or 2 Days then 24*2*60 etc..
I want to have acomapct formula rather than use a lot of IF conditions..if possible..
Bookmarks