Hi
Newbie here - so I hope this gets posted ok, I am a frequent user of excel and at reasonably knowledgable level.
When importing data into excell, each cell has an apostrophe before the data even though the apostrophe was not on the original text.
If you look at the text in the cell, you cannot see the apostrophe, but if you look at the same text in the function bar you can see it. Bizarre! This affects all text, be it numbers, dates, text, postcodes etc. I have hundreds of rows and several columns so there are thousands of cells. I want to get rid of the apostrophe without editing individual cells.
In the cell the text will appear like this: Surrey
But in the function bar it will appear like this: 'Surrey
The data is imported from a non excel database.
can anyone help?
Bookmarks