Many applications that export to Excel, export the data with the apostrophe character at the front of the string. One way of removing this character is to use the clean() function:
If in cell A1 you have: ‘output
Then in cell B1 type =clean(A1). The result will be: output
- Using Right() and Left() Functions to Remove Text from a String – Excel Today I came across a problem I see at least...
- Removing #N/A error in Excel using ISNA() The #N/A error happens most often when a lookup function...