Converting text file to excell

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:21 PM GMT

Question

I have a file in notepad that I want to dump into a spreadsheet or just extract the email address. Here is part of the sheet. Can you help?

"100014","ALINE","BAKER","RT. 1 BOX 426","DANVILLE","AR",,"72833","5012292051",,"","1046","1046","Active","250","172.149.198.28" "100015","JUAN CARLOS","ZAMORA","3131 NW 154TH TER","OPA LOCKA","FL",,"33054","3056818263",,"","0","0","Active","300","24.171.138.186" "100016","KATHLEEN","BAEZ","94-32 85 AVE 2FL","WOODHAVEN","NY",,"11421","7188056032",,"","0","0","Active","100","68.165.140.12" "100017","MIKE","MCCULLER","420 NORTH C","MCALESTER","OK",,"74501","9184205715",,"","0","0","Active","125","208.191.70.97" "100018","CARLOS","HARO.SR.","6809 CEDAR STREET","HUNTINGTONPARK","CA",,"90255","3233043837",,"","0","0","Active","50","216.50.231.110" "100019","JUSTIN","BOSINSKI","129 THORNCLIFF RD","BUFFALO","NY",,"14223","7168759705",,"","0","0","Active","100","24.52.96.80" "10002","JAMES","JONES","13908 TROPICANA DR","HAGERSTOWN","MD","USA","21742","3017974860",,"","0","0","Active","400", "100020","LINDA","REED","4974 GLENALDEN COVE","SOUTHAVEN","MS",,"38672","6626433388",,"","230","230","Inactive","100","199.82.243.74" "100021","CYNTHIA","CORDRAY","29001 NORRIS RD 27","BOZEMAN","MT",,"59718","4065228592",,"","0","0","Active","2000","64.154.121.165" "100022","VERTRICIA","BURGESS","2003 FULTON DR.","HUNTSVILLE","AL",,"35810","2566036505",,"","0","0","Inactive","100","68.159.128.69" "100023","AC","BURRELL","124 ALLEN AVE","SHREVEPORT","LA",,"71101","3183441420",,"","0","0","Active","30","152.163.213.61" "100024","RESA","JASCOURT","18 MAPLEWOOD COURT","GREENBELT","MD",,"20770","3013453583",,"","660","660","Active","10","138.88.180.245" "100025","RUSSELL","GROVES","1046 S OURAY ST","AURORA","CO",,"80017","3037513005",,"","21","21","Inactive","10","197.171.246.207" "100026","IGNE","DUMASIUTE","BAYONET ST.380","NEW LONDON","CT",,"06360","8604420631",,"","0","0","Active","10","213.226.140.116" "100027","RICHARD","GISMONDEI","2790 HARVARD PLACE","BALDWIN","NY",,"11510","5166900121",,"","0","0","Active","400","24.185.241.43" "100028","JACK","HALE","6918 TADWORTH WAY","ROCKLIN","CA",,"95677","9167913224",,"","3670","3670","Active","10","69.19.152.10" "100029","LU-GRAY","HILL","5621- D LAKE MURRAY BLVD","LA MESA","CA",,"91942","6194606600",,"","0","0","Active","2000","68.8.83.214" "10003","ROBERT","BERISH","414 E. CLEMENTS BRIDGE RD","RUNNEMEDE","NJ","USA","08078","18569392022",,"","292","292","Active","50", "100030","MIMI","BAKKE","20507 BIRCH PLACE","OCEAN PARK","WA",,"98640","3606655832",,"","0","0","Active","100","216.177.251.92" "100031","ROBERT","GOMEZ","5071 GARRISON ST 104","WHEATRIDGE","CO",,"80033","3034038021",,"","0","0","Active","50","64.207.44.65" "100032","NICHOLAS","KERSTETTER","4117 HICKORY RD","SCHNECKSVILLE","PA",,"18078","6107996288",,"","7300","7300","Active","30","207.172.249.4"

Answer

Excel will import that file just fine. I just tested it. When you start importing it, just pick comma as your text delimiter and it will work perfectly.

Advertisement

©2021 eLuminary LLC. All rights reserved.