Double height cell in xlsx becomes two rows in xls

I have been sent a xlsx (Excel 2010) spreadsheet which I have to import into Access. The row shows in the xlsx sheet as double height with the text layout as shown below

Apple
Fruit Date Quantity Country

But each entry in their own single cell in the one row

i.e. the fruit type is on a higher level than all the others

When I cut and paste into excel 2003 it pastes as two rows (duplicating my access import problem)

I have tried formatting the cells so that the text shows in a standard cell height (align top, bottom etc.) and looks as if it’s all in aligned correctly but when I cut and paste into excel 2003 it still pastes as two rows.

Is there a way of correcting the xlsx formatting please

Thanks

Pieter

Sample.xlsx

Did I attach sample file correctly? - new to forum

I used excel 2010 as there are 190,000 rows. Converting to 2003 not an option I'm afraid. I'm aware I could split into smaller no of rows and still use 2003 but the data I am being sent is increasing exponentially so I'd rather solve the format problem. I use Access 2003 (deliberately as unhappy with later version's relational integrity). Therefore cannot import from xlsx directly. However can save xlsx to csv and import - if it wasn't for this single to double line problem.

Thanks for the help

Pieter

Thanks. As soon as you said non printing char it clicked. I tried your substitute formula but when I dragged down it just repeated the text. I also tried =CLEAN(B2) just in case there were other non printing chars lurking around. Same problem.

Obviously being new to 2010 I’m missing something. I tried it in 2003 and worked no problem so no typos. Helper column formatted as general.

Thanks for taking the time to help a newbie to 2010

Pieter

The final problem - showing formulas - require creating a new helper column in a different place, clicking show formula then don't show formula, format as text then reformat as general and then the function worked.

Pieter