Can't seem to find a formula to remove square brackets around a hyperlink within a table

[Florida1510]

Struggling to find a formula that will work. I'm trying to create a formula to remove square brackets around a hyperlink with a table. I have tried Replace first and last with no luck. Here is my situation I have a table that exports data in this format [https://newtool.web.bbc.com/incident/activeincidenttemplate?incident_id=210954] I then convert the link to a hyperlink in the next cell. However I'm struggling for a formula that will remove those darn brackets.
Any assistance/ guidance/ How to videos would be greatly appreciate. I know it's something easy that I'm missing. Thanks in advance I truly appreciate the message boards assistance!!

Owen

 

[JoeMo]

Book1
	A	B
2	[https://newtool.web.bbc.com/incident/activeincidenttemplate?incident_id=210954]	https://newtool.web.bbc.com/incident/activeincidenttemplate?incident_id=210954
Sheet1

Cell Formulas
Range	Formula
B2	B2	=SUBSTITUTE(SUBSTITUTE(A2,"[",""),"]","")

 

[Florida1510]

Book1
	A	B
2	[https://newtool.web.bbc.com/incident/activeincidenttemplate?incident_id=210954]	https://newtool.web.bbc.com/incident/activeincidenttemplate?incident_id=210954
Sheet1

Cell Formulas
Range	Formula
B2	B2	=SUBSTITUTE(SUBSTITUTE(A2,"[",""),"]","")

Joe,
Love your response I so relate especially at the end of the day! Thank you so much that worked perfectly!!! Have a great day.

 

[Peter_SSs]

Another option might be

=MID(A2,2,LEN(A2)-2)

 

[JoeMo]

Joe,
Love your response I so relate especially at the end of the day! Thank you so much that worked perfectly!!! Have a great day.

You are welcome - thanks for the reply.

 

[Florida1510]

Another option might be

=MID(A2,2,LEN(A2)-2)

Peter,

Thank you I will try this today I appreciate you taking the time out of your day to assist! Thanks again