Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page text-to-Fields failing - how get null for missing values?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-09-2016, 10:59 AM
xor xor is offline text-to-Fields failing - how get null for missing values? Windows 10 text-to-Fields failing - how get null for missing values? Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Maybe this can be of some help.

http://www.andypope.info/charts/brokenlines.htm
Reply With Quote
  #2  
Old 06-09-2016, 08:36 PM
guthrie guthrie is offline text-to-Fields failing - how get null for missing values? Windows 7 64bit text-to-Fields failing - how get null for missing values? Office 2010 64bit
Novice
text-to-Fields failing - how get null for missing values? 		 
Join Date: Mar 2011
Posts: 10
guthrie is on a distinguished road
Default
Wow - creative - but complex, and a marginal result!

I think I'll just make a macro to build a copy of the data, but not copying NA cells.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
text-to-Fields failing - how get null for missing values? Display Null Values in Pivot as 0 lornalou Excel 2 06-02-2016 10:39 AM
text-to-Fields failing - how get null for missing values? Linking fields to pull values from one field to another KWH Word Tables 3 01-27-2016 02:25 PM
text-to-Fields failing - how get null for missing values? Displaying FORMTEXT fields when merge fields are empty or null sfkHooper Mail Merge 6 01-19-2016 04:24 PM
text-to-Fields failing - how get null for missing values? Eliminating zeros, null values and negatives in a column jannie Excel 1 06-22-2011 07:03 PM
Fields controlled by List box values farfromapro Word 0 02-11-2009 02:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:01 PM.

Contact Us - Privacy Statement - Top

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