[b]Possible to extract this complicated partial data in Excel?[b]

I need to extract partial contents of a cell..I have an Excel spreadsheet that contains around 1500 entries per month & i need to manage it please anyone can help me how i can extract these data in this format-

1. Customer No. (In Red Color)
2. Customer Name (In Red Color)
3. Shop Name (In Red Color)

I dont need rest of the data just want to extract data in red, i tried alot using left/right/mid functions but all data in cells are not same somewhere name goes large & some where shop name..
i hope i can get help here....
9752438923 ,SANJAY Requested by BPL MAHAVIR SHOPE CENTRE ,9993955094,
9752439363 ,RAMA Requested by BPL MAHAVIR SHOPE CENTRE ,9993955094,
9752439507 ,GAGAN Requested by BPL MAHAVIR SHOPE CENTRE ,9993955094,
9752439521 ,PANCHAM Requested by BPL MAHAVIR SHOPE CENTRE ,9993955094,
9752439538 ,RAJ Requested by BPL MAHAVIR SHOPE CENTRE ,9993955094,
9752439549 ,SUKHRAM Requested by BPL MAHAVIR SHOPE CENTRE ,9993955094,
9752453661 ,HARIRAM Requested by BPL POOJA PAN CENTRE(VIKASH NAGAR) ,9993837968,
9752454258 ,RAJESH Requested by BPL SONI TELECOMS ,9685885431,
9752454265 ,SURESH Requested by BPL SONI TELECOMS ,9685885431,
9993654778 ,LILADHAR Requested by BPL VARANAYEM MOB.(BADORA) ,9993835451,
9993656162 ,LALIT Requested by BPL AMIN MOBILE ,7869004508,
9993657976 ,JAGANNATH Requested by BPL PAPPU PAN ,9752450145,
9993693151 ,RAKESH Requested by BPL AAYESHA MOBILE ,7898064177,
9993695151 ,KAUSU Requested by BPL AMIN MOBILE ,7869004508,
8349275069 ,PRAVEEN Requested by BHPD Bothra Mobile ,9893070141,RD=9993925158 for activation.

Have you tried using Text to Columns? You can set it to separate by spaces, commas, or both depending on what you're looking for. That seems like it would fit your needs.

See if the attached is what you are after.

Yes i have tried text to columns...but it isnt working for me cell contains large text they get extracted to next columns after that i have to rearrange all

---------- Post added at 11:52 AM ---------- Previous post was at 11:48 AM ----------

Originally Posted by jindon

See if the attached is what you are after.

Hey thanks a lot jindon sir it is working...i wonder how u did that ?? & how i can do that. I have to manage lots of data rather then typing i can save my time by this. Help me to know how i can do that. thankk you so much

---------- Post added at 11:56 AM ---------- Previous post was at 11:52 AM ----------

Originally Posted by MarvinP

Hi deepz12 and welcome to the forum,

See the attached with some helping columns to show what I was doing. This is what I think you want.

Yes this is what i want...& thanks how u did that ? i need to understand that formula...i hope it will work for all cells without any problem. & why it is not working for H15 that coloumn is showing Value ??

---------- Post added at 11:58 AM ---------- Previous post was at 11:56 AM ----------

I need more help on excel regarding. Daily i maintain a datasheet of various products i need to do that in quick and simple way...tricks are working here wow

Here's the code

Please Login or Register  to view this content.

WOW thankyou so much u are awesome

@ deepz12

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.