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
If you have problems that require extra assistance, feel free to reach out to our team.

Anyone can post questions in the comments, to the left, and the ShippingEasy Customer Success team will gladly assist.


ShippingEasy accounts on a paid plan will find additional resources in the upper left corner in app.

1-512 | Email | Chat

Fully registered accounts may email, call, or chat with our team.
Trial accounts may email or call.

Comments

Please sign in to leave a comment.



Community    browse  

COMMUNITY FORUMS
FEATURE REQUESTS

Questions & Answers

Issues & Bugs

Productivity

Partners

Shipping

Inventory

Marketing