新聞財經娛樂♬資訊 News Economy

Thx for your ot

Have a nice day

Duncan

Thanks

Hello everyone, while duncanb7's solution worked in one column, for whatever the reason does not work on other columns.  I have looked at all of the cell's formatting and this does not solve the problem totally.
To add more clarification to the origin of this problem; the content of this Excel file comes from the conversion of a pdf to txt, then opened with Excel to form the xlsx file.  I suspect that through all of the conversions the content got corrupt.
This issue is not all that important for me solve at this time, so I am tabling the problem, but issuing the points shortly.
Thank you all for the help.

Column J is probably formatted as Text; change the cell(s) or entire column to "General" then press [F2] and [Enter] on that first cell in J1.

-Glenn