#1
|
|||
|
|||
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 Last edited by 16NOV2020; 11-17-2020 at 08:11 AM. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Intelligent Mail Bar Codes | gw1500se | Excel | 0 | 05-26-2017 06:52 AM |
Macro to keep first instance and remove duplicates in certain column | zhead | Excel | 2 | 03-18-2015 10:16 AM |
Macro to remove blank column | netchie | Word VBA | 4 | 03-14-2013 02:22 PM |
Intelligent document -> outlook conversion? | spoonerm | Word | 3 | 10-04-2011 08:20 AM |
How to do intelligent autonumbering? | nwong1288 | Word | 0 | 02-26-2010 01:25 PM |