It certainly works for me, once can of course change it to either text or
numbers

=IF(LEN(B1)0,ROW(),"")



--


Regards,


Peo Sjoblom




"Robi" wrote in message
...
Hi I'm using excel 2007 ..

I read this topic but FOR text it is not working =IF(ISTEXT(B1),ROW(),"")

but for numbers it is working =IF(ISNUMBER(B1),ROW(),"")

is there anything different for 2007