SELECT BRACKET NUMBERS

Closed
DON - Feb 7, 2010 at 09:03 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 7, 2010 at 10:30 AM
Hello,

hi can you give me a macro code or excel formula to get the details i want in a cell.

my excel data is like this, in column A i enter all the data and i want to SELECT the number that enclose in open and closed parenthesis ex: (54564) copy in column B.



COLUMN A COLUMN B

PM 104 METALIC (54564) JAPAN 54564
PM 103 JACQUARD (45817) KOREA 45817
PM 124 METALIC (64512) CHINA 64512


THANKS AND REGARDS

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 7, 2010 at 10:30 AM
try this, presuming that value is in cell a1

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1) -1)
0