I have a situation where I need to extract value sitting within parentheses.
ie
(12) Product Number 1
(123) Item Information
…
So I would need ONLY
12
123
Hi,
A simple formula could be like
=Replace(Replace([Field];"(";"");")";"")
Or something complex, could be
=Substr([Field];Pos([Field];"(")+1;Pos([Field];")")-1)
Thanks,
Mohammed
You are the MAN, I was trying to get the Substr work and kept getting cut short. Thanks!