Find/Replace a single quote
Posted by Dave Stimpson on September 28, 1999 2:24 PM
I've been passed a spreadsheet which contains numbers - however some of the numbers have a '(single quote) prefix which turns them into text - however the way the data has been created these are not obvious i.e. they are not left justified. I'd like to use a Find / Replace function to get rid of the single quotes, bur Excel cannt find the value ' (unlike WORD where you can find special characters). Is there a quicker way to to this rather than the goto -> special -> constant text commands?