Thanks for the reply. I tried saving the Excel file as csv. But the solution seems to be difficult. I have converted the RPA Challenge Excel file to csv. The ghost cells remain. http://www.rpachallenge.com/
It is also possible to count with regularized expressions and looping. But it is slow.