Text formatting in table

[D_HL]

Good morning, 

I have a data connection to a SharePoint site where I am bringing in a description field, free type box. When using in a table I have a line break where there is none in the source. I have unchecked "show whitespace" in Power Query, which has removed them in the display there, however still getting the break in the visual? 

E.g. there should be no break after plan...

Thanks 

Dan 

[amitchandak · Accepted solution]

@D_HL , In power query, try clean

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4

[D_HL]

Sorry @amitchandak it's now taken some spacing out and merged words together.... is there anyway to avoid that? 

[D_HL]

perfect! Thanks @amitchandak