Function delcr2000(r As Range)
Dim arr() As String
ReDim arr(200)
For i = 1 To Len(r)
arr(i) = Mid(r, i, 1)
If Mid(r, i, 1) = " " Then arr(i) = " "
If Mid(r, i, 1) = Chr(10) Then arr(i) = " "
Next i
delcr2000 = Join(arr(), "")
End Function
'Удалить данные после "("
Function delcr2000(ByVal r As Range)
Dim arr() As String
ReDim arr(200)
For i = 1 To Len(r)
arr(i) = Mid(r, i, 1)
If Mid(r, i, 1) = "(" Then
arr(i) = " "
Exit For
End If
Next i
delcr2000 = Join(arr(), "")
End Function