Hi Everybody:
I have a spreadsheet in Excel 2000 that has data imported from another system (maybe Oracle?) and I am trying to sort one of the columns. Although the data looks fine at quick glance, when I click on the individual cells, I can see up in the formula bar that many of the cells have an apostrophe before the numbers. This character is, obviously, affecting my abilities to sort.
I discovered the CLEAN function, but I have never used it before. Do you think this will solve my problem? If so, can you please help me generate a formula - the Help feature has been completely UNhelpful?!
My cell should read something like:
AL0051
But when I click in the formula bar, I see that it really says:
'AL0051
Can you please help me get rid of the ' ....I have a LOT of cells!
Any help and or suggestions you may have would be greatly appreciated.
Many thanks, in advance!
I have a spreadsheet in Excel 2000 that has data imported from another system (maybe Oracle?) and I am trying to sort one of the columns. Although the data looks fine at quick glance, when I click on the individual cells, I can see up in the formula bar that many of the cells have an apostrophe before the numbers. This character is, obviously, affecting my abilities to sort.
I discovered the CLEAN function, but I have never used it before. Do you think this will solve my problem? If so, can you please help me generate a formula - the Help feature has been completely UNhelpful?!
My cell should read something like:
AL0051
But when I click in the formula bar, I see that it really says:
'AL0051
Can you please help me get rid of the ' ....I have a LOT of cells!
Any help and or suggestions you may have would be greatly appreciated.
Many thanks, in advance!