Formula to replace two different delimiters

[Ross191]

I have two different delimiters ("[]" and "()") that I'm trying to replace with a space. They start at the beginning of the cell. Below includes an example with the solution ("desired output" column) I'm trying to get to with an excel formula:

Data	Desired Output (looking for a formula to get these details)
[Name] Details (which can include a long string of text)	Details (which can include a long string of text)
(Name) Details (which can include a long string of text)	Details (which can include a long string of text)

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

Thanks for that.
How about

Fluff.xlsm
	A	B
1
2	[Name] Details (which can include a long string of text)	Details (which can include a long string of text)
3	(Name) Details (which can include a long string of text)	Details (which can include a long string of text)
Sheet5

Cell Formulas
Range	Formula
B2:B3	B2	=TEXTAFTER(A2,{"] ",") "},1)