Removing Characters to right of

[VegasL]

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

[kwright90]

Try this...

=LEFT(A1,10)


"LEFT" representing counting letters from the left.
"A1" being which cell to count in.
"10" being how many letters to count. This is concidering "domain.com" being 10 letters/spaces.

[VegasL]

thanks kwright, i apprecaite your help

i guess i should have been more clearer

i will have i.e

www.domain.com?
www.domain.com/sfasf/dsafsdf.htm?sdafdsfsd
www.domain.com/prod/?dafsdfasd

etc

bacially i am wanting to remove any characters after the ?, with anything before question mark being a variable number of characters under 100, hope that makes sense.

[kwright90]

I see...

I'm no expert but I am familiar with the "=LEFT(A1,10)" formula. Your issue is something I am not familiar with. I am sure there is someone here that will help. Sorry bro.

[marcs]

=left(a1, Search(a1, "?"))

[VegasL]

thanks marc, i tried that and got #VALUE error

but it definitely seems like ur going in right direction,

all i want for it to do is anything after the "?" to not display, thus look only display everything before the "?"


so in case of www.domain.com/sfasf/dsafsdf.htm?sdafdsfsd

i want it to only display final result being www.domain.com/sfasf/dsafsdf.htm


etc.

[marcs]

Sorry, I messed that up.

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

If the -1 isn't there, then it will return the string with the "?"

[VegasL]

thanks. it worked pefectly. really appreciate everyones help here. Youre awesome.