How to: Remove the ' before a tracking number on a CSV download

In ShippingEasy, our CSV downloads will have an appostrophe ' before each tracking number. This is because spreadsheets will automatically truncate this number.

If you would like to omit this, just select the column on the spreadsheet, then do CTRL+F (for Windows) or COMMAND+F (for Mac) and "Find" ' and leave the "Replace" value blank.

This will cause the numbers to truncate. To change this, change the column format from "General" or "Number" to "Text".

Related articles:

How to: Merge multiple columns of data in Excel without losing any data
How to: Export tracking numbers back to my original CSV file