Removing only the first numbers from a mixed cell

[Kinghart]

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)

 

[Faseeh]

Hi Kinghart


Assuming your data is in A2 use this formula in cell C2:

=LEFT(A2,FIND(" ",A2,1))

Regards,

Faseeh

 

[Faseeh]

..Hope it helps!


Regards,

Faseeh


(I edited a duplicate post, sorry for that)

 

[Kinghart]

thanks man... so short and so sweet.. and works perfectly

 

[Faseeh]

You are welcome any time!


Faseeh