Florida1510
New Member
- Joined
- Mar 13, 2020
- Messages
- 35
- Office Version
- 2010
- Platform
- Windows
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
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