I am trying to clean up some data that was put into an excel spreadsheet. The data is laced with those square blocks that typically are indicitave of broken data or spaces.
However, when I tried to use any of the many msoffice(2003) utilities to work with data, none of them would accept these square blocks as input.
For instance, I could not copy and paste one of them into the find/replace box, or any other similar utility.
I tried character map but those utilities don’t accept different outputs (also, I think that the square blocks could be any of hundreds of fonts). The net result is that I cant do anything with them except work with them manually but there is way to much data.
I believe that the data was pulled from a filemaker pro data base (www.filemaker.com) and put into an excel spreadsheet. I have very little hope of finding the person who did this.
I would love to convert these, delete these, get them into a suitable entry box, or even be able to find out what they are. I am currently exploring filemaker client/server to use the drivers.
Any help would be greatly appreciated.
