Forum Discussion
D_HL
3 years agoFrequent Visitor
Text formatting in table
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
D_HL , In power query, try clean
Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4
3 Replies
- amitchandakSuper User
D_HL , In power query, try clean
Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4
- D_HLFrequent Visitor
perfect! Thanks amitchandak
- D_HLFrequent Visitor
Sorry amitchandak it's now taken some spacing out and merged words together.... is there anyway to avoid that?