using various data from a source outside of excel

J

Jennifer

I want to know how to convert data typed in word (in a
sentence format)to seperate columns in excel.
The "sentence" might contain a product, a price and a
date. The next "sentence" appears on the next line and
contains the same information (product, price and date),
but does not line up in column format.
 
F

Frank Kabel

Hi
without more information about your exact data structure: difficult to
say. But you may start with 'Data - text to columns' within Excel
 
Top