For Each t As Table In Tables For Each r As Row In t.rows For Each c As Col In t.cols If c.IsString AndAlso c.DataCol.Expression = "" Then Dim str As String = r(c.name) str = str.Replace(chr(10), "").replace(" ", "") str = " " & str.Replace(chr(13), vbcrlf & " ").trim() r(c.name) = str End If Next Next Next