Hello!
I am looking for an excel formula (not VBA) to remove all occurrences of values [?], {?}, (?) and ?^ from A1
Value in A1: hello[bob]car[army]is{hope}bicyclez^red(or)blue
Value in B1 would be: [bob]
Value in B2 would be: [army]
Value in B3 would be: {hope}
Value in B4 would be" z^
Value in B5 would be" (or)
Value in C1 would be the value of A1 minus all the values listed on B1:B5 or hellocarisbicycleredblue
FYI: The can be multiple digits in the [ ] or { } or ( ). For the ?^, there is only 1 digit followed by the ^
Thanks in advance if you are up for the challenge!!
I am looking for an excel formula (not VBA) to remove all occurrences of values [?], {?}, (?) and ?^ from A1
Value in A1: hello[bob]car[army]is{hope}bicyclez^red(or)blue
Value in B1 would be: [bob]
Value in B2 would be: [army]
Value in B3 would be: {hope}
Value in B4 would be" z^
Value in B5 would be" (or)
Value in C1 would be the value of A1 minus all the values listed on B1:B5 or hellocarisbicycleredblue
FYI: The can be multiple digits in the [ ] or { } or ( ). For the ?^, there is only 1 digit followed by the ^
Thanks in advance if you are up for the challenge!!