I have a spreadsheet with several thousand lines. The data has been extracted from a database and the column that I need to work with has descriptions that are inconsistently set up. The information is recorded but not in a format that makes standard sorting easy.
I want to identify items using a simple code in another column which I could then sort by.
I thought I could use a series of IF commands however, I am not having much success getting Excel to find a text string and return a numerical value.
Can someone provide a suggestion.