I need help to extract text and numbers from cells. I am uploading a workbook showing what kind of raw data I normally get and what results I am expecting after extraction. Thanks for help in advance.
Hmm, you are not just extracting but replacing some char.
This won't be quick and easy, as you will need to build your list and/or logic first on what characters to replace and what chars to omit etc.