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

Was this article helpful?
0 out of 0 found this helpful

Comments

Add a Comment

Please sign in to leave a comment.