I can guess how you want it formatted, but is it possible for you to attach a sample excel sheet with the desired tabs/columns how you want it?
On May 18, 3:31 pm, Susan 1 <sunni...@gmail.com> wrote: > Hi ~ > > Wondering if you could assist me with the Text import wizard to configure > the columns and tab delimiter for the attached txt file. And then send me > the steps. > > I will be needing to do this every week to the same types of txt files, > importing into Excel and I’d like to create a Macro for this but cannot > figure out how to set the tab/columns. > > Thanks, > > Sunnie > > 2065409868_05-03-2011.txt > 6KViewDownload -- ---------------------------------------------------------------------------------- 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/discussexcel
