How do I get this Function to Work in G-Docs

[fansoffloyd]

Please help! need to get this formula to work on google docs.

Got some great help in getting an excel formula that references cell B1 with a list of names on A1:A833 .

Entered The following into module 1:

Function GetNames(Paragraph As Range, Names As Range) As String
Dim Cell As Range
GetNames = ","
For Each Cell In Names
    If Cell <> "" Then
        NameArray = Split(Cell, ",")
        If InStr(Paragraph, Trim(NameArray(0))) > 0 And InStr(GetNames, "," & Trim(NameArray(0)) & ",") = 0 Then
            GetNames = GetNames & Trim(NameArray(0)) & ","
        End If
    End If
Next Cell
If Len(GetNames) > 0 Then GetNames = Mid(GetNames, 2, Len(GetNames) - 2)
End Function

Entered :
=getnames(B1,A1:A833)

into cell 3. and it works great! But I can't upload it to googledocs with the macros enabled. Anyone know how to enter this into to google or have a formula that does something similar?

Excel sheet attached. THANK YOU SO MUCH!

Copy of wuzwrong-2.xlsm