IF-ELSE condition : If cell does not contain certain variables, apply a certain formula

[Mithun.Uchil]

Hi,

I'm trying to separate the "h" and "min" using the space in between with the 'LEFT' and 'MID' formula (eg. 2h 45min)

In certain cells only the "h" or "min" is present (eg '2h' or '40min'). So I need to create a small excel "IF-ELSE" formula where, if the cell does not contain "h" or "min", it returns me the string present in the cell. I tried the following to separately get the 'h' and 'min' string:

=IF(SEARCH(" ",LEFT(C2,(FIND(" ",C2,1)-1)),C2))
=IF(SEARCH(" ",MID(C2,FIND(" ",C2)+1,256)),C2))

The formula isn't executing and is giving a variable issue. Where am I going wrong?

[bebo021999]

using SUBSTITUTE to replace "min" with " min", "h" with "h " (with 1 space), then trim to be 1 space remains.

=TRIM(SUBSTITUTE(SUBSTITUTE(C2,"min"," min"),"h","h "))