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
but if you use a math operation, eg -- , the numbers act a numbers and the 'text as text and return a false, yet the istextPlease Login or Register to view this content.
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;
Richard.Please Login or Register to view this content.
Bookmarks