View Single Post
 
Old 11-16-2020, 08:30 AM
16NOV2020 16NOV2020 is offline Windows 10 Office 2019
Novice
 
Join Date: Nov 2020
Posts: 4
16NOV2020 is on a distinguished road
Default USPS Intelligent Mail Encoder How to Remove Text from Column?

(I edited my original post because I gave a link to the excel file from the USPS...that was an error, it's an integration .exe and I understand you folks not wanting to do an install...so, try again)


I'm using the USPS Intelligent Mail Barode Excel file to print envelopes. It is annoying that the spreadsheet automatically puts "input track string must have 20 digits" in EVERY blank row!


I want a blank row to print blank..as it is now, I must delete the "input track string must have 20 digits" text in every row that should be blank...time waster and annoying!


Cannot figure out how to get rid of the text? Everything I've tried results in the sheet blowing up on me.


The attached pic shows the contents of J2 that produce the text string "input track string must have 20 digits"and for K2, it says K2 = J2...so I just need to know what J2 is all about and how I get rid of that text string and just have a blank cell.



Good luck! I surrendered
Attached Images
File Type: jpg TrackingString.JPG (41.1 KB, 13 views)

Last edited by 16NOV2020; 11-17-2020 at 08:11 AM.
Reply With Quote