---------- Forwarded message ---------- From: Inderbir Singh <inder...@gmail.com> Date: Fri, Dec 17, 2010 at 2:08 PM Subject: Solution to a Problem To: xcel-mac...@googlegroups.com
Hi Friends , I have a very big problem . I need to convert the following Text file into a Excel file in the following format . Please send detailed information ASAP. Please help. Regards Inderbir Singh Kolkata -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Bones A (0612) 9460 3568 44 Mcdougall St (AM) KirribilliNSW2061 Bones A J (0617)5579 9106 22 Hickey Way (AM) CarraraQLD4211 Bones B (0612) 4324 1651 150 Maidens Brush Rd WyomingNSW2250 (No Computer) Bones B J (0612) 6583 6909 36 Bellangry Rd Port MacquarieNSW2444 Bones E M // (0612) 9771 3261 11 Hedlund St (Not Interested at all) RevesbyNSW2212 Bones E R (0612) 6584 0137 (No Answer) 46 Ackroyd St Port MacquarieNSW2444 Bones F (0612) 9818 2630 (AM) 27 Macquarie Tce BalmainNSW2041 Bones G J & W J (0612) 6652 4619 (NI) 23 Antaries Ave Coffs HarbourNSW2450 Bones H // Heather Bones (0612) 6372 0527 (Call Back at 6 AUS time) 34 Robertson St MudgeeNSW2850 Bones I J & M R (0612) 6882 4983 (NI) Sheraton Rd DubboNSW2830 Bones J (0612) 6651 1310 (No Computer) 210 Pacific Hwy North Boambee ValleyNSW2450 Bones J (0617) 5535 1220 (NI) 11 Acanthus Ave Burleigh HeadsQLD4220 Bones K // (0612) 4340 1269 Some one else 6 Garlick St KariongNSW2250 Bones K (Business) (0612) 9439 1136 37 Osborne Rd Lane CoveNSW2066 Bones K (0612) 9453 5593 50 Peacock Pde Frenchs ForestNSW2086 Bones L (No Computer) (0612) 9879 3069 43 Gladesville Rd Hunters HillNSW2110 Bones M // Megan Pam Bones (0612) 9809 3663 (Call towards the end of the Shift 11 Falconer St Use the reference of Mr. Bones) West RydeNSW2114 Bones N J (0612) 6372 1925 Hung Up 473 Burrundulla Rd MudgeeNSW2850 Bones R A No Longer (0612) 9621 2972 38 Stewart Ave BlacktownNSW2148 Bones Ron O & M (Call Back after 15 Minutes) (0617) 5593 7256 51 Mattocks Rd Burleigh WatersQLD4220 Bone A (0612) 6972 1916 (Call Back) 82 Monash St West WyalongNSW2671 0411 356 661 Mobile Service Bone A (0612) 4384 3949 (No Computer) 16 Anniversary Av TerrigalNSW2260 Bone A D & R E (0612) 4944 8779 21 Patterson Cl WhitebridgeNSW2290 Bone A E & K A (0612) 6662 1673 // 061732559250 (Anthony Bone) 232 Sextonville Rd CasinoNSW2470 Bone A J (0613) 5466 2257 (AM) 1661 Lexton-Ararat Rd AmphitheatreVIC3468 Bone Alan (AM) (0612) 4385 9357 41 Terrigal Drv TerrigalNSW2260 Bone A P (AM) (0612) 6297 7456 44 Conway St KarabarACT2620 Bone A R (0612) 9879 3723 5 Western Crs GladesvilleNSW2111 Bone B (0612) 4957 8052 35 High St Lambton NorthNSW2299 Bone B (0617) 4636 2689 207 Stenner St Centenary HeightsQLD4350 Bone B (0613) 5424 8184 (No Computer) 41 Trentham Rd TyldenVIC3444 Bone B J & D F (0612) 6556 1553 8 River St HarringtonNSW2427 Bone C (0612) 6382 2726 4500 Olympic Hwy YoungNSW2594 Bone C (0612) 4990 2040 29 Cooper St CessnockNSW2325 Bone C // Samuel BanEyle (0612)6294 0794 // Call back tuesday night 7.30PM AUS time 54 Clare Dennis Av GordonACT2906 Bone C (0613) 9733 5338 2 Kiama Ct MooroolbarkVIC3138 Bone C (0612) 4862 5313 50 Boardman Rd BowralNSW2576 Search results Bone C (0612) 4732 6206 43 Ladbury Ave PenrithNSW2750 Bone Chris A & Silvia Bone (0612) 4369 0316 19 Pomona Rd Empire BayNSW2257 Bone Christine Call back after 7pm Aus time (0612) 6658 4714 44 Moller Drv SawtellNSW2452 Bone C J (0612) 4472 2825 88 Vista Ave CatalinaNSW2536 Bone C K DNC (0612) 9521 3098 273 Forest Rd KirraweeNSW2232 Bone C N (0617) 5564 7457 74 Wardoo St AshmoreQLD4214 Bone C N 06111 576 601 4/ 53 Bauer St SouthportQLD4215 Bone D (0612) 8901 3063 7 Wyomee Av PymbleNSW2073 Bone D (0617) 5631 4428 37 Jack Nicklaus Way ParkwoodQLD4214 Bone D (0612) 9651 4512 9 Elabana Way Castle HillNSW2154 Bone Dany (0612) 6651 6922 10 A Frances St Coffs HarbourNSW2450 Bone D (0612) 6331 3757 13 Ussher Crs WombianaNSW2799 Bone D (0612) 9555 8362 13 Perry St LilyfieldNSW2040 Bone Daphne DNC (0612) 6943 1401 17 Wood St StockinbingalNSW2725 Bone David (0612) 4930 5585 100 Clarence St WallalongNSW2320 Bone D B DNC (0617) 5546 7139 60 Vaughan Drv OrmeauQLD4208 Bone D & D (0617) 5571 6744 37 Jack Nicklaus Way ParkwoodQLD4214 Bone Diane (0612) 4965 9369 5 Minchinbury Cl EleebanaNSW2282 Bone D J & Jones Louise (02) 9144 7060 160 Warrimoo Ave St IvesNSW2075 Search results Bone D J & N L (02) 6342 5541 11 Shepherd Ave CowraNSW2794 Bone D L (02) 6944 8233 1 Glenwood Burra CreekNSW2722 Bone Mr D L (02) 4997 1284 7 Curlew Ave PindimarNSW2324 Bone D & L (02) 6241 6089 7 Tambo St KaleenACT2617 Bone D M & H E (02) 9451 7459 20 Seaview Pde BelroseNSW2085 Bone D & T (02) 4927 5216 30 Kilgour Ave MerewetherNSW2291 Bone D W (02) 4948 2664 58 Albert St Warners BayNSW2282 Bone E J (02) 4984 9469 27 Canomii Cl Nelson BayNSW2315 Bone E L & J (02) 4984 2921 16 Pirralea Pde Nelson BayNSW2315 Bone F G (02) 6680 3769 35 The Esplanade New BrightonNSW2483 Bone G (07) 4634 0415 9 Jacqueline St GlenvaleQLD4350 Bone G (02) 4961 0526 3 Cleary St HamiltonNSW2303 Bone G C (02) 9427 5274 33 Bridge St Lane CoveNSW2066 Bone G E (02) 6662 3140 62 Centre St CasinoNSW2470 Bone G F (02) 4325 4881 211 Brisbane Water Drv Point ClareNSW2250 Bone G G (02) 4284 2445 35 Cresting Ave CorrimalNSW2518 Bone G J & P A (07) 5539 3971 25 Jaguar Drv BundallQLD4217 Bone G Q & J M (02) 4942 6722 45 Patterson Cl WhitebridgeNSW2290 Search results Bone G T (02) 9971 4443 165 Pacific Pde Dee WhyNSW2099 Bone G & Z (02) 6362 3521 833 Mitchell Hwy OrangeNSW2800 Bone H (02) 9402 2901 8 Churchill Cr Allambie HeightsNSW2100 Bone Helen (02) 6765 5106 61 Minnamurra Crs TamworthNSW2340 Bone H M (02) 4987 6656 179 Adelaide St Raymond TerraceNSW2324 Bone I (02) 4323 7288 22 Yallambee Ave Gosford WestNSW2250 Bone I (02) 6345 0806 Trout Farm Rd Wyangala DamNSW2808 Bone Mr I L (02) 6945 3271 731 Cootamundra Rd CoolacNSW2727 Bone J (02) 6259 6504 2 Warby Pl CharnwoodACT2615 Bone J (07) 5527 3510 5 Sharne Crt CarraraQLD4211 Bone J (02) 9971 5125 70 Howard Av Dee WhyNSW2099 Bone J (03) 4433 1189 36 Olinda St Quarry HillVIC3550 Bone J (02) 6681 3472 4 Carrington St BallinaNSW2478 Bone J (02) 9501 1596 28 Horns Av Gymea BayNSW2227 Bone Dr J (02) 9908 4256 65 Spencer Rd MosmanNSW2088 Bone J (02) 9576 5416 3 Auburn St Nth SutherlandNSW2232 Bone J (02) 4262 6109 41 Robert St DaptoNSW2530 Bone J (02) 4961 1841 55 Chatham St HamiltonNSW2303 Bone J (02) 6751 1660 313 Warialda St MoreeNSW2400 Search results Bones K (02) 9439 1136 37 Osborne Rd Lane CoveNSW2066 Bones K (02) 4340 1269 6 Garlick St KariongNSW2250 Bones K (02) 9453 5593 50 Peacock Pde Frenchs ForestNSW2086 Bone K (02) 4976 2145 5 Tradewinds Ave Summerland PointNSW2259 Bone K (02) 8765 0060 6 Brewer Ave Liberty GroveNSW2138 Bone K (07) 5594 6291 29 Ben Hogan Crs ParkwoodQLD4214 Bone K (02) 6331 3465 262 Howick St BathurstNSW2795 Bone K (02) 6942 6464 48 Hurley St CootamundraNSW2590 Bone K C & M L (02) 4973 4247 7 Kalani Rd Bonnells BayNSW2264 Bone Mr Kevin (02) 9976 3346 11 Wentworth St ManlyNSW2095 Bone K J (02) 9817 0768 25 Wharf Rd GladesvilleNSW2111 Bone K J & R S (02) 4392 3769 67 Hughes Ave KanwalNSW2259 Bone K L (03) 5027 3760 97 Cadell St WentworthNSW2648 Bone K & L (02) 4456 4189 11 Coolibah Ave Lake ConjolaNSW2539 Bone A E & K A (02) 6662 1673 232 Sextonville Rd CasinoNSW2470 Bone C K (02) 9521 3098 273 Forest Rd KirraweeNSW2232 Bone J & K (02) 4868 1112 14 Narellan Rd Moss ValeNSW2577 Bone N K & W A (07) 5538 6660 76 Gibraltar Drv Surfers ParadiseQLD4217 Bone P & K (02) 4447 8321 74 Gorindah Rd Falls CreekNSW2540 Bone S K (02) 9544 8262 3 Redfern Pl GymeaNSW2227 Search results Bone S K (02) 4358 1316 16 Kellys Rd Lake MunmorahNSW2259 Bone W K (02) 4392 1340 99 Tuggerawong Rd WyongahNSW2259 Search results Bones L (02) 9879 3069 43 Gladesville Rd Hunters HillNSW2110 Bone L (02) 6373 7864 733 Bocoble Rd BocobleNSW2850 Bone L (02) 6584 8562 36 Bounty Ave Lake CathieNSW2445 Bone L (02) 9623 6587 59 Brisbane St Oxley ParkNSW2760 Bone L F (03) 5027 3454 0 Darling View" WentworthNSW2648 Bone L J (02) 9871 8562 22 Stirling Ave North RocksNSW2151 Bone D J & Jones Louise (02) 9144 7060 160 Warrimoo Ave St IvesNSW2075 Bone D J & N L (02) 6342 5541 11 Shepherd Ave CowraNSW2794 Bone Mr D L (02) 4997 1284 7 Curlew Ave PindimarNSW2324 Bone D L (02) 6944 8233 1 Glenwood Burra CreekNSW2722 Bone D & L (02) 6241 6089 7 Tambo St KaleenACT2617 Bone E L & J (02) 4984 2921 16 Pirralea Pde Nelson BayNSW2315 Bone Mr I L (02) 6945 3271 731 Cootamundra Rd CoolacNSW2727 Bone J L (07) 5562 2326 12 Staysail Crs Clear Island WatersQLD4226 Bone K C & M L (02) 4973 4247 7 Kalani Rd Bonnells BayNSW2264 Bone K L (03) 5027 3760 97 Cadell St WentworthNSW2648 Bone K & L (02) 4456 4189 11 Coolibah Ave Lake ConjolaNSW2539 Bone N J & R L (02) 4283 4944 27 High St CorrimalNSW2518 Bone N L (02) 6059 2242 31 Melrose Drv WodongaVIC3690 Bone P C & J L (07) 5578 7178 309 Ron Penhaligon Way RobinaQLD4226 Search results Bone R L (02) 6825 1920 17 Yalcogrin St GulargamboneNSW2828 Bone R L (02) 4571 2532 10 Ignatius Ave North RichmondNSW2754 Bone R L (02) 6026 7517 7 Palmerston St BarnawarthaNSW3688 Bone S L (02) 4333 6806 18 Karooah Ave Blue BayNSW2261 Bone S L 47 068 128 67 Bank St MolongNSW2866 Search results Bones M (02) 9809 3663 11 Falconer St West RydeNSW2114 Bones E M (02) 9771 3261 11 Hedlund St RevesbyNSW2212 Bones I J & M R (02) 6882 4983 Sheraton Rd DubboNSW2830 Bones R O & M (07) 5593 7256 51 Mattocks Rd Burleigh WatersQLD4220 Bone M (02) 4969 8634 109 Lawson St HamiltonNSW2303 Bone M (02) 6071 8657 209 Lockharts Gap Rd HuonVIC3695 Bone M (02) 9878 3380 2 Waratah St EastwoodNSW2122 Bone M (07) 5524 8626 2 Falcon Way Tweed Heads SouthNSW2486 Bone M (02) 4284 0076 8 Organs Rd BulliNSW2516 Bone M (02) 9603 1319 4 Burford St MintoNSW2566 Bone M (02) 6684 1905 76 Alidenes Rd Wilsons CreekNSW2482 Bone M (02) 9705 0144 43 Noble St Five DockNSW2046 Bone M (02) 9150 5292 156 Kingsgrove Rd KingsgroveNSW2208 Bone M (02) 9528 7195 11 Short St Oyster BayNSW2225 Bone M (03) 5744 1115 7 Havenstock Drv BurramineVIC3730 Bone M (02) 4997 2735 33 Spinifex Ave Tea GardensNSW2324 Bone Martin G & Shiralee A (02) 6847 1099 6 Milda St GilgandraNSW2827 Bone M & C (02) 4733 2968 94 Ridgetop Drv Glenmore ParkNSW2745 Bone M & C (02) 4392 3001 35 Dean Ave KanwalNSW2259 Bone M & D (02) 6367 7446 19 McLauchlan St CumnockNSW2867 Search results Bone M I (02) 4455 3965 16 Fitch St UlladullaNSW2539 Bone D M & H E (02) 9451 7459 20 Seaview Pde BelroseNSW2085 Bone G Q & J M (02) 4942 6722 45 Patterson Cl WhitebridgeNSW2290 Bone H M (02) 4987 6656 179 Adelaide St Raymond TerraceNSW2324 Bone K C & M L (02) 4973 4247 7 Kalani Rd Bonnells BayNSW2264 Bone N M (02) 4341 5218 23 Lake Rd BlackwallNSW2256 Bone N W & H M (02) 9899 8804 3 A Woodchester Cl Castle HillNSW2154 Bone P & M (02) 4421 2995 31 Illaroo Rd Nowra NorthNSW2541 Search results Bones N J (02) 6372 1925 473 Burrundulla Rd MudgeeNSW2850 Bone N (02) 6622 6384 50 Hindmarsh St LismoreNSW2480 Bone N B (07) 5530 4473 47 Veronica Drv TallaiQLD4213 Bone N J & R L (02) 4283 4944 27 High St CorrimalNSW2518 Bone N K & W A (07) 5538 6660 76 Gibraltar Drv Surfers ParadiseQLD4217 Bone N L (02) 6059 2242 31 Melrose Drv WodongaVIC3690 Bone N M (02) 4341 5218 23 Lake Rd BlackwallNSW2256 Bone N W & H M (02) 9899 8804 3 A Woodchester Cl Castle HillNSW2154 Bone C N (07) 5564 7457 74 Wardoo St AshmoreQLD4214 Bone D J & N L (02) 6342 5541 11 Shepherd Ave CowraNSW2794 Bone W N (07) 5591 3275 45 Allan St SouthportQLD4215 Search results Bone P (02) 9958 8497 21 Hector Rd WilloughbyNSW2068 Bone P (02) 4957 4051 370 Newcastle Rd Lambton NorthNSW2299 Bone P (02) 6241 8219 3 Drummer St HarrisonACT2914 Bone Mr P (02) 9634 6094 55 Cambewarra Ave Castle HillNSW2154 Bone P (02) 4384 3847 18 Barnhill Rd TerrigalNSW2260 Bone P A (07) 5528 9973 17 Bayview St Runaway BayQLD4216 Bone P C & J L (07) 5578 7178 309 Ron Penhaligon Way RobinaQLD4226 Bone P G (02) 4329 2733 6 Della Cl NararaNSW2250 Bone P I & R J (07) 4661 1652 13 Panorama Crt WarwickQLD4370 Bone P & K (02) 4447 8321 74 Gorindah Rd Falls CreekNSW2540 Bone P & M (02) 4421 2995 31 Illaroo Rd Nowra NorthNSW2541 Bone P & S (02) 9548 0204 89 Corinth Rd HeathcoteNSW2233 Bone A P (02) 6297 7456 44 Conway St KarabarACT2620 Bone G J & P A (07) 5539 3971 25 Jaguar Drv BundallQLD4217 Bone R C & P A (03) 5831 7278 9 Quinan Pde SheppartonVIC3630 Bone R (02) 4233 1605 6 Terralong St KiamaNSW2533 Bone R (02) 4545 1275 10 Ignatius Ave North RichmondNSW2754 Bone R (02) 4284 6031 3 Terania St Russell ValeNSW2517 Bone R (02) 4950 2110 29 Curry St WallsendNSW2287 Bone R (02) 4961 4736 67 Clyde St Hamilton NorthNSW2292 Bone R (02) 9836 3194 5 Ben Pl Beaumont HillsNSW2155 Bone R (02) 6761 5524 40 Cunningham St WestdaleNSW2340 Bone R (02) 6027 1573 121 Hodgson La YackandandahVIC3749 Bone R (02) 6255 2179 29 Griffiths St HoltACT2615 Bone R (02) 9909 0648 73 Undercliff St Neutral BayNSW2089 Bone R (02) 6585 5937 4 Abel Tasman Drv Lake CathieNSW2445 Search results Bone S (02) 9439 3369 42a Park Rd St LeonardsNSW2065 Bone S (02) 9556 3944 58 Roach St ArncliffeNSW2205 Bone S (02) 6056 2439 21 Stapleton Crt WodongaVIC3690 Bone S (02) 9437 4674 18 Devonshire St Crows NestNSW2065 Bone T (02) 6020 9548 18 Hemlock Crt BarandudaVIC3691 Bone T 18 526 995 0 Springvale Rd Lockwood SouthVIC3551
OUTPUT.xls
Description: MS-Excel spreadsheet
