I need to parse information based on part description, and one of the
characters used is a quotation mark that denote inches.
(1) How can I use the FIND, or LEFT/RIGHT/MID, etc., functions to find
quotations marks? (Everytime I use =""" or <""" as the criteria, XL
say it is an error. I also tried using CODE(34), ASCII for ", but XL
won't let me.
(2) I have empty cells (never used, 'virgin' cells) that meet the
criteria ="". Often times, however, the ="" used in COUNTIF, SUMIF, and
others do not recognize what appear to be empty/blank cell as such.
Is there a way to really clear a cell so it meets ="" ? So far I have
tried hitting delete with the cell selected, copying another empty cell
(that met the ="") to the desired cell, but so far nothing has worked.
Thanks -
Alex
--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile:
http://www.excelforum.com/member.php...fo&userid=4029
View this thread:
http://www.excelforum.com/showthread...hreadid=391361