using various data from a source outside of excel

[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.

 

[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