View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
A123BELLE A123BELLE is offline
external usenet poster
 
Posts: 3
Default Convert a text file to columes

I'm trying to convert a text file with multiple rows (10) of repeated data.
The "Text to Columns" function in Excel can only sort one row. Is there a way
in Excel where I can format it to convert these data into just one row?