K
Ken
Excel2003
Col D contains text such as ... 15/3 ... 1/4 ... 8/14 ... etc ... with 1 to
3 numerics occuring on either side of the "/".
In a conditional Formula I need to treat any "text" that looks like a number
on the left side of the "/" as a number.
I was using ... Sum(left(D5,1) ... as part of my formula & this was working
great until I encountered the 2 & 3 characters on the left side of the "/".
Now I am stuck.
Thanks ... Kha
Col D contains text such as ... 15/3 ... 1/4 ... 8/14 ... etc ... with 1 to
3 numerics occuring on either side of the "/".
In a conditional Formula I need to treat any "text" that looks like a number
on the left side of the "/" as a number.
I was using ... Sum(left(D5,1) ... as part of my formula & this was working
great until I encountered the 2 & 3 characters on the left side of the "/".
Now I am stuck.
Thanks ... Kha