Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-16-2020, 08:30 AM
16NOV2020 16NOV2020 is offline USPS Intelligent Mail Encoder How to Remove Text from Column? Windows 10 USPS Intelligent Mail Encoder How to Remove Text from Column? Office 2019
Novice
USPS Intelligent Mail Encoder How to Remove Text from Column?
 
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
 



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
USPS Intelligent Mail Encoder How to Remove Text from Column? Macro to remove blank column netchie Word VBA 4 03-14-2013 02:22 PM
USPS Intelligent Mail Encoder How to Remove Text from Column? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft