select text between delimiters
Hello, I'm trying to write a formula to select text that lies between the delimiters [ ].All text in my column appears as below:RinseAid[Apex.Rinse]*(Temp-130)RinseAid[AutoDri]*(Temp-130)RinseAid[Bright&Dry]*(Temp-130)RinseAid[Clarity]*(Temp-130)...I want to keep only the text between the [ ] symbols:Apex.RinseAutoDriBright&DryClarityBut using a formula such as below, Iget a mesage that the formu...