View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
carolini carolini is offline
external usenet poster
 
Posts: 11
Default Text File Data Formating

I have a text file that the data wraps into a second line. How can I get the
data all on one line? See sample below: Any help would be appreciated!
Thanks!


FR#Acct # Name
Status Phone Address


001-008705 Smith, J *13A Jones PL
ACT (555)555-5555 BRONX NY 10475-3903

001-016770 Harris, H *22A Jones PL
ACT (555)555-5555 BRONX NY 10475-3904