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.

Book1
	A	B
1	https://www.youtube.com/watch?v=Hc7BjYmn9z0	Hc7BjYmn9z0
2	https://www.youtube.com/watch?v=rOG_bHqknTk&list=PLCfCFkNhhqbuX_NpY0n3tbIFHOWjwcjrJ	rOG_bHqknTk
Sheet2

Cell Formulas
Range	Formula
B1	=IF(ISERROR(SEARCH("&",A1)),RIGHT(A1,LEN(A1)-SEARCH("=",A1)),MID(A1,SEARCH("=",A1)+1,SEARCH("&",A1)-(SEARCH("=",A1)+1)))
B2	=IF(ISERROR(SEARCH("&",A2)),RIGHT(A2,LEN(A2)-SEARCH("=",A2)),MID(A2,SEARCH("=",A2)+1,SEARCH("&",A2)-(SEARCH("=",A2)+1)))

 

[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.