Remove everything after the ?

[shlomek12]

https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905?wpa_bd=1529079692726&wpa_ref_id=b_f43a5d01-81fe-4dcd-9c44-abb4a258769f_1&wpa_aux_info=__aux_info__&wpa_tag=__tag__&wpa_pos=6&wpa_plmt=__plmt__&wpa_aduid=__aduid How can I remove everything after the?

<tbody>
</tbody>

 

[Patcheen]

any good ? https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905

 

[shlomek12]

Yes this is good but how can I do it in excel?

 

[Patcheen]

can u right click it and copy and paste in the cell you want it in excel

 

[shlomek12]

I have a few hundred lines with different URL's

I want to remove it it fast

 

[jtakw]

Hi,

A couple of ways:

Book1
	A
1	https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905?wpa_bd=1529079692726&wpa_ref_id=b_f43a5d01-81fe-4dcd-9c44-abb4a258769f_1&wpa_aux_info=__aux_info__&wpa_tag=__tag__&wpa_pos=6&wpa_plmt=__plmt__&wpa_aduid=__aduid
2	https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905
3	https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905
Sheet129

Cell Formulas
Range	Formula
A2	=REPLACE(A1,FIND("?",A1),255,"")
A3	=LEFT(A1,FIND("?",A1)-1)

 

[shlomek12]

Thanks for this

How can I make this as in IF Statement?

That if the cell contains an ? , then it should run this formula

Hi,

A couple of ways:

	A
1	https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905?wpa_bd=1529079692726&wpa_ref_id=b_f43a5d01-81fe-4dcd-9c44-abb4a258769f_1&wpa_aux_info=__aux_info__&wpa_tag=__tag__&wpa_pos=6&wpa_plmt=__plmt__&wpa_aduid=__aduid
2	https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905
3	https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet129​

Worksheet Formulas Cell Formula A2 =REPLACE(A1,FIND("?",A1),255,"") A3 =LEFT(A1,FIND("?",A1)-1) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Scott Huish]

What do you need an IF for?
I'm assuming you have some that don't have the ?. Try this instead:
=LEFT(A1,FIND("?",A1&"?")-1)

Excel 2010
	A
1	https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905?wpa_bd=1529079692726&wpa_ref_id=b_f43a5d01-81fe-4dcd-9c44-abb4a258769f_1&wpa_aux_info=__aux_info__&wpa_tag=__tag__&wpa_pos=6&wpa_plmt=__plmt__&wpa_aduid=__aduid
2	https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905
3
4	http://www.google.com
5	http://www.google.com
Sheet1

Cell Formulas
Range	Formula
A2	=LEFT(A1,FIND("?",A1&"?")-1)
A5	=LEFT(A4,FIND("?",A4&"?")-1)