I have a spreadsheet with a column containing URL's.

I'd like to apply a formula to the entire column so that, if a URL has a question mark, delete the question mark and everything right of it.

I found this formula:

**=LEFT(A1, FIND("?", A1&"?")-1)**

Probably a basic question but, how to I apply this formula to an entire column that already has data (in this case the url)???

Thanks!

-Paul