如何删除U列中不可见字符和空格的VBA代码  表格是从U8系统导出来的  

Sub 删除不可见字符和空格()
    Dim ws As Worksheet
    Dim rng As Range
    Dim cell As Range

    Set ws = ThisWorkbook.Worksheets("Sheet1") '根据实际情况修改工作表名称
    Set rng = ws.Range("U2:U200")

    For Each cell In rng
        cell.Value = Replace(cell.Value, " ", "") '删除空格
        cell.Value = Replace(cell.Value, Chr(160), "") '删除不可见字符
    Next cell
End Sub

删除不可见字符