Hello,

I want to remove all characters to right off ?

for example.

domain.com?sdfasdfsfsf
domain.htm?safasfsd


etc.

so any cell a1 i have:
domain.com?sdfasdfsfsf

cell a2 I have

domain.htm?safasfsd


what is formula i would use to remove all characters to right of "?" ?

ps the characaters to right of? will vary in each cell block by type and number of characters

thanks for your help
thanks