delete text after comma how to use?

Good morning
I'm newbie in excel and search for how to remove text after comma and found this formula

=LEFT(A1, FIND(",",A1)-1)

=if(iserror(find(",",d6,1)),d6,left(d6,find(",",d6,1)-1))

I don't understand where to put these functions?

I have 1 column (A) with 20+K list of text
i want to remove all text after "," comma
like these
Émile Zola
Émile Zola, La Faute de l'abbĂ© Mouret
Émile Zola, Le Docteur Pascal
Émile Zola, The Fortune of the Rougons
Émile Zola, The Masterpiece

so i tried to put these formulas in first cell in the column then enter , nothing happened
so please help how to use these function

thanks

2nd question
to remove non english cells i found this topic

with this function also
http://www.excelforum.com/excel-prog...-language.html
how to use and where to put?

Sub x()

Dim rng As Range

With CreateObject("vbscript.regexp")
.Global = True
.Pattern = "[^\d^\w^\s-\.\,]"
For Each rng In Range("A1").CurrentRegion
rng = .Replace(rng, "")
Next rng
End With

End Sub

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Merged.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)