How to remove space which creep in while copying HTML data or converting HMTL file to Excel

Friends,

Recently I faced a issue after of converting HTML file to excel;

I was not able to take totals or use formula in converted excel.

After spending much time I have found that, the space was inserted while converting the html file to excel and due to the same no formula was working. Further, such space is not editable by using find and replace command.

Therefore, I have initially imported the html file to word file and remove the space by using find and replacement command. And thereafter, i have saved the the file and reopened it with excel. And the problem is solved.

Posting this for the benefit of other and to save the time.

Regards,
-------
CA.C.V.PAWAR
PATIL DAWARE GIRASE PAWAR & ASSOCIATES

CHARTERED ACCOUNTANTS

0253-2319641. M-9423961209

INDIAN CA - NURTURED IN INDIA, GROOMED FOR THE WORLD