Categories vs Sub-categories in my data set

You can use the LEFT function, say in column C

=Left(A2,2) Will return the 01 or 02 digits code that refers to the category here.

Then, in another column, D, you need to use VLookup function to return the name of the category using the code. If you have another standalone table with the list of category codes in column 1 and names in column 2, you can use a formula like this:

=VLookup(C2,ReferenceTable,2,0)

where:

C2: is the cell you have with the LEFT function I explained above.

ReferenceTable: The range with the standalone table with the category codes and names.

2: is the column index number for the category names in the table above.

0: is the method of selection and searching which is "Exact match" that suits your data here.

If you do not have or cannot create such a standalone table with category codes and names, this will be hard to extract data from these cells, as we do not know if the category name consists of one word or two, therefore we cannot use a character to separate the category name.

Hope this helps...