Hi Everyone, I'm trying to clean a database, It is an Excel spreed sheet which contain cells with a lot of information separated with spaces, comas, semicolons and so on... The idea that I had is to segregate the data using "text to cells" excel command and later use MS Access and the replace button to clean the data. However, somehow the replace button is not working... I don't know why...
Some ideas how can I fix this problem? will be so much appreciated...
Mario