Cell Contains text plus symbol and number How do I filter all besides the text

[Arnold]

Example


[ManufacturerName] "Bose (10)" How do I filter the column so it should read just Bose.
The number in parentheses can be from 1 to 3 digit if that makes a difference.

[pbaldy]

If it's as simple as that you could use the Left() function along with InStr() to find the first "(".

[Arnold]

Thank you.
So In my case how would you write it for [ManufacturerName]?

[pbaldy]

Oh, I thought that was the field name. In that case I'd use Mid(), with InStr() to find the first " and the (.

[Arnold]

Thank you very much.

[pbaldy]

No problem.