Seperate limited text from a cell contaning alpha numeric values

I have a huge database in this format "Sony DVD 2Pcs". Now i want to extract just "Sony DVD" from the cell. Is there any formula that could do that for me??

Hi...
you can try the below formula..

=LEFT(B13,LEN(B13)-4)

Hi Vishnu

My data is variable, it wont work on all
Here is the sample of date

Data
Sony DVD 2pcs
Rajdhani Atta 5KG
Good Night Liquid 3btls

and so on...
And i need
Sony DVD
Rajdhani Atta
Good Night Liquid

Yea, This one works.. Thanks a lot
Although didnt understand how it works...

@ martindwilson

Great solution but shouldn't the last part include a space (or other character)?

So, this: =LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&" 0123456789"))-2)

otherwise subtracting the 2 will chop off last character when no number is found

i guess, if we have a sample data, we can provide correct soluation.

@varun...will it possible for you to attach the sample data here???

@ vishnu01445

See post #5 - the OP has a solution

ya....but when we have limited info, we cannt provide correct soluation right?

thats the reason, i asked him to attach the file.

even, i am fine with post #5.....

thanks,
vishnu

Here is the Sample data


Sony DVD 2 Pcs
Mehak Amchur Powder 100 Gm Box
Hitech Rajma Chitra Regular 25
Hitech Masoor Black Large Reg 5 Kg
Mehak Haldi Powder 200 Gm Pp
Panghat Special Vanaspati 5 Ltr Jar
Mawana Premium Crystal Sugar 5 Kg
Nova Ghee 950 Ml Jar
Nova Ghee 950 Ml Jar
Mehak Garam Masala 200 Gm Pp
Saffola Gold 1 Ltr Pouch
Prs Mirch Powder
Nutrela Chunks
Stag Brand Superfine Atta
Dizzle Mitha Pan
Fortune Refined Soya Oil
Saffola Gold 15 Ltr Pet Jar
Saffola Gold
Param Premium Ghee
Dizzle Mitha Amla


I tried the formula, it even works fine when there are no numbers in the cell.
I hope I'm not missing out anything, as i said i'm still trying to work out how this formula works

Thanx for verifying..
This solution is awesum. Saved a lot of time for me

@ Varun13

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

@Cutter.

Thanx for marking it solved, i'll keep it in mind next time.

Also thanx for letting me know 'bout the star thing.