Remove the newline and enter data \n and select SQL Query

REPLACE(REPLACE(cast(BRANCHNAME as nvarchar(max)), CHAR(13), ''), CHAR(10), '')