hi...
What I'm trying to do is, I want to remove only the first numbers from a mixed cell, example:
Cell A2 states:
23 pkts x 20 gms
Cell A3 States:
440 cans x 200 ml
I want Cell C2 to say:
23
AND C3 to say:
440
I'm using this formula by the way, but its not what i actually wants..
=LEFT(E7,FIND("^^",SUBSTITUTE(" "&E7," ","^^",LEN(" "&E7)-LEN(SUBSTITUTE(" "&E7," ",""))))-1)
What I'm trying to do is, I want to remove only the first numbers from a mixed cell, example:
Cell A2 states:
23 pkts x 20 gms
Cell A3 States:
440 cans x 200 ml
I want Cell C2 to say:
23
AND C3 to say:
440
I'm using this formula by the way, but its not what i actually wants..
=LEFT(E7,FIND("^^",SUBSTITUTE(" "&E7," ","^^",LEN(" "&E7)-LEN(SUBSTITUTE(" "&E7," ",""))))-1)