VALUE

Removing leading Apostrophe (') in Excel from Numbers and Text

Removing leading Apostrophe (‘) in Excel from Numbers and Text

This question is asked by one of the member at our facebook community. He was stuck in common problem. Leading apostrophes. This is often the case if data is extracted from a famous business application Lotus Notes. If the data is copied or extracted to Excel then these unwanted characters interferes with Excel’s normal functioning. So […]