The following code:

Public Function RemoveSpaces(strInput As String)
' Removes all spaces from a string of text
Test:
If InStr(strInput, " ") = 0 Then
RemoveSpaces = strInput
Else
strInput = Left(strInput, InStr(strInput, " ") - 1) _
& Right(strInput, Len(strInput) - InStr(strInput, " "))
GoTo Test
End If
End Function

will apprently remove spaces from a text string in an Excel spreadsheet. I would like to modify it so that it removes quotes from a text string, and removes it ONLY for a particular column (say, column A). when I replace the second parameter of the InStr function from " " to " "" ", it gives me a "stack overflow" error. Help !!!

fundean