Ho all, wondering if anyone call tell me how to sort cells into appropriate columns? On the attached excel spreadsheet, I have a grocery list I copied and pasted from a website. Excel put all of the data in column A, but what I want to do is extract this data and sort it so that column A product name, would have the item description, and column B labelled item price, would show the unit price of the items, row by row. Is there any way to do this in excel using function and formulas? I know I can do it manually cell by cell, but that is time consuming. Many thanks

Attached Files

for microsoft excel forum.xlsx (10.3 KB, 11 views)