Try this to get data from brackets. It works any data inside the brackets:

=LEFT((RIGHT(A1;(LEN(A1))-(FIND("(";A1))));F2-1)





T. Valko wrote:

You're welcome. Thanks for the feedback!--BiffMicrosoft Excel MVP
26-okt.-09

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Pragmatic ADO.NET
http://www.eggheadcafe.com/tutorials...ic-adonet.aspx