Hi All,
I got a question:

If i am have a data needed to be clean, and the cell is really mess up with random number and other symbol.

For example, same data of store name are like
apple 123
apple #123
123# appl
no. 123appl NY
7-11 1234
1451 7-11
first 4 need to be changed into apple
and while the last 2 need to be 7-11 or seveneleven
need to change million cells. And there are over thousands of store name.

Any suggestions?
Thanks!