This is probably an Excel format problem but the difficulties arise with the mail merge.

I have a 10000 named spreadsheet. The address for the customer is Address 1 (House Number); Address 2 (Street name): Town; County; Postcode
This is standard UK address format.

I have no problems with 95% of the records as the address is , for example,

2 Smith Street etc

These records mail merge fine

However there are certain addresses which may be alpha/numeric - 2b or Flat 4. These don't sort properly but finish up at the end of the street. That doesn't matter. BUT when I merge, they merge not as 2b but as 0 which is a real PITA having to manually correct.

I have tried to format as general, numeric and text and get no difference.
Is there any way that I can get the proper address over.