Re: The link. I’m loathe to install any programs on the company’s computer.
Most of our data arrives as Excel files. It needs to be fixed-format text in order to run through my programs. Excel won’t save files as fixed-format text in the way they need to be saved, so I get rid of double-quotes, commas, and any non-display characters and save it as a .csv file. This file is imported into Access and then exported as text, defining the field lengths and starting positions. Commas and non-display characters cause fields to be shifted when saved as a .csv file (which kind of defeats the purpose of making a fixed-position file! )
In an Excel file, with wrapping turned on, the non-display characters result in two lines being displayed in a cell; like this:
123 FAKE ST
With wrapping turned off, it looks like this:
123 FAKE STADMIN BUILING
What I do is delete the non-display character and what follow it, so that I only have one line per cell: 123 FAKE ST. If there are a great many non-display characters in the file, I can F&R ALT-010 with a pipe. (This is useful when I actually want what follows the break.) Since I can’t use ALT codes from my Mac, I use NoOneSpecial’s technique of copying the Excel file into Word and using the drop-down menu to accomplish the same. Obviously that’s ridiculous if I only need to edit two cells.
Usually wrapping is turned off, or else I turn it off. So seeing which cells might have NDCs in them is difficult (see the previous example). When I had Excel 2003, the NDCs would show up as little squares, similar to this: – except they’re not square brackets but actual little squares. This made them easy to see:
123 FAKE STADMIN BUILDING
So what I want to find out, is if there is any way to make the NDCs visible as above, and as they were in Excel 2003. Getting rid of them isn’t a problem; it would just be convenient if I could see them.