Thanx Abhishek, Still waiting for my query to be resolved, meanwhile I'm sharing the .txt file for your better insight.
Regards Sandeep On Wed, Feb 20, 2013 at 12:34 PM, Abhishek Jain <abhishek....@gmail.com> wrote: > Hi Sandeep, > > Welcome to the group. I hope that the experts here would help resolve your > query. > > Meanwhile, could you also share with us the text file (in its original > format) from which you have imported this data. I believe it would help in > getting a better insight. > > Thanks, > > Abhishek > > > On Wed, Feb 20, 2013 at 12:05 PM, Sandeep <sandeeppathak...@gmail.com> > wrote: >> >> Dear Experts, >> >> This is my first interaction with this group though I have been a >> member of this group for a long. Let me introduce my self as Sandeep, >> works for the Hospital in Accounts department. Most of my work is >> related with excel and I do have a sound knowledge of excel but not to >> the expert level as I see you guys participate. And I appreciate this. >> >> Coming to my query, actually I have converted .txt file to .xls in >> which party names and thier TIN/Registration numbers are all clubbed >> in one column which needs to be further bifurcated to another two >> columns. I need your help in this regard, .... >> >> Please provide the solution.... >> >> >> Best Regard, >> >> Sandeep >> >> -- >> >> >> >> Winning doesn't always mean first, but means that you're doing better >> than what you've done before... >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- Winning doesn't always mean first, but means that you're doing better than what you've done before... -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
--------------------------------------------------- -------------- ----------- -------------------------- ------------ ------------------ ---------------- S.No Name and Address TIN Tax Invoice Date of Description of Commodity Taxable Amount Tax Amount of Purchasing dealer No. Tax Name Code Quantity Value of Tax of Invoice Invoice Measure of Goods Charged 4.5 % 13.5 % --------------------------------------------------- -------------- ----------- -------------------------- ------------ ------------------ ---------------- 1 SURGICAL MEDICAL CENT 09559000904 915 25.07.2009 Med.& Serg.Items 2 3700.5 166.50 0.00 3867 "KANJARI SARAI , KOTHIWALAN,MBD" 2 POOJA AGENCIES 09558903480 958 31.07.2009 Med.& Serg.Items 5 1427.73 64.27 0.00 1492 "NEAR SHIV DURGA MADIR,KOTHIWAL NAGAR,MOR" 3 P.P.TRADER 09159202235 283 31.07.2009 Med.& Serg.Items 615 10458.38 470.62 0.00 10929 "C-2/65,MANSAROVER COLONY,MBD" 4 O.P.SCIENTIFIC CORPN. 1190 31.07.2009 Med.& Serg.Items 500 6000 270.00 0.00 6270 5 SURGICAL MEDICAL CENT 09559000904 956 31.07.2009 Med.& Serg.Items 281 5957.2 253.25 44.55 6255 "KANJARI SARAI , KOTHIWALAN,MBD" 6 RAHUL MEDICOS 09359001933 15 1/8/2009 Med.& Serg.Items 25 999.04 44.96 0.00 1044 "SHANKAR NAGAR,DAULAT BAG,MBD" 7 N.N.DRUG AGENCIES 09459000891 8511 1/8/2009 Med.& Serg.Items 100 1101.42 49.58 0.00 1151 "OPP.NEEM KI PYAU,PATPAT SARAI,MDB" 8 S.R.ENTERPRISES 09359201560 1286 1/8/2009 Med.& Serg.Items 152 6813.37 306.63 0.00 7120 "ASHIANA,B-33,GANDHI NAGAR,MORDABAD" 9 S.R.ENTERPRISES 09359201560 1295 1/8/2009 Med.& Serg.Items 9 612.94 14.06 0.00 627 "ASHIANA,B-33,GANDHI NAGAR,MORDABAD" 10 HEMKUNT MEDICAL STOR 09960604312 62 01.08.2009 Med.& Serg.Items 50 6983.72 314.28 0.00 7298 "B-41 KRISHNA COLONY CHANDRA NAGAR,0" 11 I.K. MEDICOS 09360604141 968 02.08.2009 Med.& Serg.Items 162 4688.05 210.95 0.00 4899 "CHOWMUKHA PUL,PATTAN WALI GALI,MBD" 12 S.R.ENTERPRISES 09359201560 1318 3/8/2009 Med.& Serg.Items 812 1860.28 83.72 0.00 1944 "ASHIANA,B-33,GANDHI NAGAR,MORDABAD" 13 N.N.DRUG AGENCIES 09459000891 8616 3/8/2009 Med.& Serg.Items 15 873.67 39.33 0.00 913 "OPP.NEEM KI PYAU,PATPAT SARAI,MDB" 14 Y.P MED.SUPP. 09358900275 1370 3/8/2009 Med.& Serg.Items 360 2589.49 116.51 0.00 2706 15 RAJESH MEDICOS 09460601010 424 03.08.2009 Med.& Serg.Items 3 1529.2 68.80 0.00 1598 "RETI STREET , MBD." 16 VINEET MEDICAL STORE 09959001572 4772 03.08.2009 Med.& Serg.Items 557 1912.89 86.11 0.00 1999 "TARI KHANA,COURT ROAD,MORAABAD" 17 S.R.ENTERPRISES 09359201560 1317 03.08.2009 Med.& Serg.Items 302 7044.95 317.05 0.00 7362 "ASHIANA,B-33,GANDHI NAGAR,MORDABAD" 18 POOJA AGENCIES 09558903480 963 03.08.2009 Med.& Serg.Items 1090 11425.85 514.15 0.00 11940 "NEAR SHIV DURGA MADIR,KOTHIWAL NAGAR,MOR" 19 NEW CITY MEDICAL STOR 09259200311 8048 03.08.2009 Med.& Serg.Items 13 10093.65 5.35 0.00 10099 "B-97,GANDHI NAGAR,PRINCE ROAD,MBD" 20 SHARAD MEDICOS 09958903237 5225 03.08.2009 Med.& Serg.Items 235 2073.71 93.29 0.00 2167 "GULAL GALI,RETI STREET MORADABAD" 21 I.K. MEDICOS 09360604141 969 4/8/2009 Med.& Serg.Items 130 1834.46 82.54 0.00 1917 "CHOWMUKHA PUL,PATTAN WALI GALI,MBD" 22 JAYANT MEDICAL AGENCY 09558902499 2901 4/8/2009 Med.& Serg.Items 130 3044.96 137.04 0.00 3182 "GULAL GALI,RETI STREET,MORADABAD" 23 AGARWAL DRUG AGENCY 09158900959 980 4/8/2009 Med.& Serg.Items 480 3250.74 146.26 0.00 3397 "DINDARPURA,MORADABAD" 24 N.N.DRUG AGENCIES 09459000891 8658 04.08.2009 Med.& Serg.Items 90 1342.84 45.08 46.08 1434 "OPP.NEEM KI PYAU,PATPAT SARAI,MDB" 25 HARSH MEDICAL HALL 09358905654 32 04.08.2009 Med.& Serg.Items 20 1680.4 75.60 0.00 1756 "BEHIND ZIYARAT,KANTH ROAD,MBD" 26 S.R.ENTERPRISES 09359201560 1333 04.08.2009 Med.& Serg.Items 137 3333.97 150.03 0.00 3484 "ASHIANA,B-33,GANDHI NAGAR,MORDABAD" 27 S.R.ENTERPRISES 09359201560 1343 05.08.2009 Med.& Serg.Items 333 3430.64 154.36 0.00 3585 "ASHIANA,B-33,GANDHI NAGAR,MORDABAD" --------------------------------------------------- -------------- ----------- -------------------------- ------------ ------------------ ----------------