text-to-Fields failing

guthrie · #3 06-08-2016, 08:48 PM

Yes, I did that, but the na() values are not treated as missing values in the plot, even though that option (show empty cells as gaps) is selected.
Manually deleting these resulting NA fields, and the plot is correct.

Seems like only missing (empty) cells will plot as gaps, and formulae are able to produce blank or NA results, not empty.

I used this:

Quote:

=IF(
TRIM(MID(SUBSTITUTE($C25," ",REPT(" ",LEN($C25))),((COLUMNS($C25:F25)-1)*LEN($C25))+1,LEN($C25)))="",
NA(),
VALUE(TRIM(MID(SUBSTITUTE($C25," ",REPT(" ",LEN($C25))),((COLUMNS($C25:F25)-1)*LEN($C25))+1,LEN($C25)))))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display Null Values in Pivot as 0	lornalou	Excel	2	06-02-2016 10:39 AM
Linking fields to pull values from one field to another	KWH	Word Tables	3	01-27-2016 02:25 PM
Displaying FORMTEXT fields when merge fields are empty or null	sfkHooper	Mail Merge	6	01-19-2016 04:24 PM
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