Hi Crazycucumber & Fairestcape, i managed to find a solution that may help others too.

Removing line break from Excel
In Excel, choose Edit>Replace
Click in the Find What box
Hold the Alt key, and (on the number keypad), type 0010
This represents a line break in Excel.
You won't see anything in the 'Find What' box

In the Replace with box, type the characters that you want to use
instead of a line break eg .<br />

Click the Replace All button

This worked a treat. Many thanks.