Editing large text cells

[Manolocs]

Hello, I am wondering if there is a way to check a list of columns for a missing close parenthesis, I mean there is an open parenthesis, without a close ou vice versa.
Thanks in advance.

 

[Rick Rothstein]

By the way, when I try the Function in post #9 with „(((ksfsf)gdg” I get „Missing” as a result.

Good catch (sloppy testing on my part). Here is corrected code... if there is a backward pair, it reports that no matter what else may be wrong... for any other missing part, it gives the count of how many are missing.

[table="width: 500"]
[tr]
	[td]Function CheckParen(ByVal S As String) As String
  Dim X As Long
  For X = 1 To Len(S)
    If Mid(S, X, 1) Like "[!()]" Then Mid(S, X) = " "
  Next
  S = Replace(S, " ", "")
  Do While Len(S) > 1 And S Like "*()*"
    S = Replace(S, "()", "")
  Loop
  If S Like "*)(*" Then
    CheckParen = "Backward"
  ElseIf Len(S) Then
    CheckParen = "Missing " & Len(S) & " " & Choose(InStr("()", Left(S, 1)), ")", "(")
  End If
End Function[/td]
[/tr]
[/table]