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