Replacing 'new line' separator with just a space in VBA

[killpaddy]

I have an excel file like the one contained in the link below:

https://docs.google.com/spreadsheet/...kJEdEZDejRTbFE


I want some VBA code (perhaps using the 'Replace' function) that changes the text in column A to one line rather than having new lines

e.g. in cell A2
'Quick Turn 8; 10
8 Station; 8 Position'

Becomes:

'Quick Turn 8; 10; 8 Station; 8 Position'

I think it would be fairly simple except I don't know what the character for 'next line' is.

Thanks in advance for any help

 

[wigi]

Columns(1).Replace Chr(10), "; "