View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Krish Krish is offline
external usenet poster
 
Posts: 6
Default Convert text to columns

I need to convert a .txt file which has data without a commas.
00120* ROASTED RED PEPPER SPREAD RETAIL 44.590 CS
02951*GORDAL OLIVES UNPITTED 2/5 LB 59.910 CS

The first 5 characters represent the product number and the text followed by
until the space is the Product description, then Pack size, Price and Unit
of Measure.

Seeking from the experts the best way to convert this data to columns
without much hassle.

Thanks.

Krish