Extra space in cells from a Sharepoint export

[manatee2000]

Hello All,

I am trying to figure out why there are extra <cr> in cells in a worksheet connected to a Sharepoiint list. The lines do not show in the sharepioint list or in dataview, and a cut and paste as plain text does not solve the issue. I appreciate any guidance.

 

[VoG]

Try selecting the cells then running the TrimAll macro http://www.mvps.org/dmcritchie/excel/join.htm#trimall