Hopefully there is something simple that someone knows that will save me a bunch of trouble.
I’ve got a file that I pulled from a mainframe and am trying to do some comparisons in Excel. They are phone numbers from a couple of sources that I’m trying to check if one source has been updated and not the other. The problem is that they are not formatted the same. Actually this isn’t the problem I’m posting about, because I’ve already stripped out all of the spaces, /'s, etc. and have appended country codes etc so I have two strings of numbers (actually a character string that contains mainly numbers) to compare. I’ve then used an If function to tell me which match and which don’t.
Here is the real problem. Many of them appear to match, but my If function returns “Bad” (my un-matched value). But when I double click on one of the cells it “refreshes” and I suddenly get a “Match.” Rather than double clicking on 3,000 cells or so, is there any way to double click the entire column? I’ve tried things like double clicking the column header, cutting and pasting, cutting and pasting special-values, re-calculating the spreadsheet, and nothing works other than double clicking the cells.
Somebody surely has a quick and easy solution. I’m using Excel 97 if that helps.