Hi,
this is really just a theory question, if you have text in a cell , 1,2,3,a,b,c,d 9 ,
and then use text spilt, you get a spill of text values ; so
ISTEXT( TEXTSPLIT(F5,",") ) = true ,
but if you use a math operation, eg -- , the numbers act a numbers and the 'text as text and return a false, yet the istext
function has just returned text for all the values,
so are they text or number in spill as above, I've attached sheet, this was about removing numbers but this question arose;
TEXTJOIN( "",TRUE,IF(ISNUMBER(--TEXTSPLIT(F8,",")),"",TEXTSPLIT(F7,",")))
Richard.
Bookmarks