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


Add a Comment

Please sign in to leave a comment.

  • csv
  • spreadsheet
  • replace
  • orders uploads
  • #pendo
  • answerbot_article_public