Hi I'm new to all this excel data stuff!

however I have survey data results and in one of the cells it has multiple values which are separated between ; and some are not separated at all e.g B&Q; The Range; Wickes The Garden Shop

also there are spelling mistakes everywhere and vereation of the word B&Q e.g b+q, B n Q

I need to add count up all of the B&Q, Wickes ect..


is there an easy way for this?

thank you