How to extract video id from url

[Nayasoch]

Hello EVeryone,
I was wondering if there is anyway or Formula to extract Video id from youtube url .

For example below is url
https://www.youtube.com/watch?v=Hc7BjYmn9z0

and video id is
Hc7BjYmn9z0

Is there any formula that I can use?
Thanks in advance.

 

[Scott T]

Try

=RIGHT(A1,LEN(A1)-SEARCH("=",A1))

 

[Nayasoch]

It extract whole text after =
which i s

rOG_bHqknTk&list=PLCfCFkNhhqbuX_NpY0n3tbIFHOWjwcjrJ

<colgroup><col width="104"></colgroup><tbody>
</tbody>

but video id is only
rOG_bHqknTk

 

[Scott T]

When you data differs like this please give multiple examples of your data so the person helping can take the variations into account.

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">https://www.youtube.com/watch?v=Hc7BjYmn9z0</td><td style=";">Hc7BjYmn9z0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">https://www.youtube.com/watch?v=rOG_bHqknTk&list=PLCfCFkNhhqbuX_NpY0n3tbIFHOWjwcjrJ</td><td style=";">rOG_bHqknTk</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B1</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">SEARCH(<font color="Green">"&",A1</font>)</font>),RIGHT(<font color="Red">A1,LEN(<font color="Green">A1</font>)-SEARCH(<font color="Green">"=",A1</font>)</font>),MID(<font color="Red">A1,SEARCH(<font color="Green">"=",A1</font>)+1,SEARCH(<font color="Green">"&",A1</font>)-(<font color="Green">SEARCH(<font color="Purple">"=",A1</font>)+1</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B2</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">SEARCH(<font color="Green">"&",A2</font>)</font>),RIGHT(<font color="Red">A2,LEN(<font color="Green">A2</font>)-SEARCH(<font color="Green">"=",A2</font>)</font>),MID(<font color="Red">A2,SEARCH(<font color="Green">"=",A2</font>)+1,SEARCH(<font color="Green">"&",A2</font>)-(<font color="Green">SEARCH(<font color="Purple">"=",A2</font>)+1</font>)</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

 

[Nayasoch]

Thank you Colonel..it'll work. Since many of videos url I"m taking from playlist for which second solution will work and few of them I pick url from separate ..for which first will work. I'd be glad if there is any working formula for both condition in same line but If it's not possible then it is also a great help for me. Thanks again.