How to remove characters within (XXX)

**ElenaAguirre** · 04-11-2013, 07:41 AM

Hi all, hopefully you can direct me to the correct logic..

I am looking for a formula that can remove any character within two characters, in this example the characters are "()"... hope the example is clear.

Original:

30K (reduce PO from 50k to 30k)

Result:
30K ()

I would think a macro is the way to go..but my knowledge in that field is very limited. Do you know if a formula can help?
Thank you!