K
Kristie
Hello,
I have a long list of data points that contain both number and text. I am
trying to create a new list of data points in an adjacent column that copies
the numbers and leave a blank if the original cell contains text.
I=IF(ISTEXT(B4),"",B4) or =IF(ISTEXT(B4)," ",B4,)) or =IF(ISTEXT(B4),,B4,))
None of these work for me because it either leaves a text blank, a zero or a
text. With the new list of data (with no text) I am using a macro to
normalize the data for a week. I am looking for the weekly minimum and
average. So of course writting zero's throws off my minium and leaving a
text blank does not let me do any type of adding when using a macro. If I
simply hit delete in the cell the macro works just fine. Or if I create the
new list and do replace " " with and leave it blank it also works. Is there
a way to leave a completly blank cell no text types at all.
I have a long list of data points that contain both number and text. I am
trying to create a new list of data points in an adjacent column that copies
the numbers and leave a blank if the original cell contains text.
I=IF(ISTEXT(B4),"",B4) or =IF(ISTEXT(B4)," ",B4,)) or =IF(ISTEXT(B4),,B4,))
None of these work for me because it either leaves a text blank, a zero or a
text. With the new list of data (with no text) I am using a macro to
normalize the data for a week. I am looking for the weekly minimum and
average. So of course writting zero's throws off my minium and leaving a
text blank does not let me do any type of adding when using a macro. If I
simply hit delete in the cell the macro works just fine. Or if I create the
new list and do replace " " with and leave it blank it also works. Is there
a way to leave a completly blank cell no text types at all.