Left/right find

Hi all,

I have a range of text cells in A1:A6, formatted as such:

(1)2080(2)Main Building(3)045(4)General Teaching(5)Basic Teaching(6)Basic Teaching
(1)2080(2)Main Building(3)116(4)Circ/Anc(5)Other(6)Other
(1)2080(2)Main Building(3)031(4)Science(5)Specialist Practical(6)Specialist Practical
(1)2080(2)Main Building(3)060(4)Hall(5)Halls(6)Halls
(1)2080(2)Main Building(3)128(4)Teaching Storage(5)Teaching Storage(6)Teaching Storage

What I would like is for a formula to go in Column B that extracts the text found between (3) & (4) from the correspoding cell in Column A.

Although in this instance the position of (3) is the same in every cell, this WILL move so was hoping to incorporate a FIND into whatever formula used.

Expected Results...

045
116
031
060
128


Many thanks,

Jason

Originally Posted by nflsales

=MID(A1,SEARCH("(3)",A1)+3,SEARCH("(4)",A1)-SEARCH("(3)",A1)-3)
try this formula

Perfect, thank you very much!