Follow

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

Created:   |   Updated:

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

Comments

Please sign in to leave a comment.

Community    browse  

COMMUNITY FORUMS
FEATURE REQUESTS

Questions & Answers

Issues & Bugs

Productivity

Partners

Shipping

Inventory

Marketing