Replacing () around numbers of varying length, in text thread of varying length

[MargieRoberts]

This one is baking my noodle. I need the digit in () extracted into a separate column. These are all values in Column A, though some columns are indented. Ideas, please??

01. First Week (1)
None (1)
10/09/2018 (1)
Initial Onboarding Complete
01. First Week (1)
None (1)
07/30/2018 (1)
Initial Onboarding Complete
01. First Week (1)
None (1)
10/09/2018 (1)
First Week Onboarding Complete
01. January (2)
None (2)
03/12/2018 (2)
SolidFire 4805 Support Renewal
Amtelco Infinity Support Renewal
01.03.2019 (5)
None (5)

 

[Scott T]

Assuming that there is only one set of parentheses like your sample this should work.

Book1
	A	B
1	01. First Week (1)	1
2	None (1)	1
3	10/09/2018 (1)	1
4	Initial Onboarding Complete
5	01. First Week (1)	1
6	None (1)	1
7	07/30/2018 (1)	1
8	Initial Onboarding Complete
9	01. First Week (1)	1
10	None (1)	1
11	10/09/2018 (1)	1
12	First Week Onboarding Complete
13	01. January (2)	2
14	None (2)	2
15	03/12/2018 (2)	2
16	SolidFire 4805 Support Renewal
17	Amtelco Infinity Support Renewal
18	01.03.2019 (5)	5
19	None (5)	5
Sheet1

Cell Formulas
Range	Formula
B1	=IFERROR(MID(A1,SEARCH("(",A1)+1,SEARCH(")",A1)-1-SEARCH("(",A1)),"")

 

[sandy666]

another way using PowerQuery (Get&Transform)

Column1	Text Between Delimiters
01. First Week (1)	1​
None (1)	1​
10/09/2018 (1)	1​
Initial Onboarding Complete
01. First Week (1)	1​
None (1)	1​
07/30/2018 (1)	1​
Initial Onboarding Complete
01. First Week (1)	1​
None (1)	1​
10/09/2018 (1)	1​
First Week Onboarding Complete
01. January (2)	2​
None (2)	2​
03/12/2018 (2)	2​
SolidFire 4805 Support Renewal
Amtelco Infinity Support Renewal
01.03.2019 (5)	5​
None (5)	5​

[SIZE=1]
let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Inserted Text Between Delimiters" = Table.AddColumn(Source, "Text Between Delimiters", each Text.BetweenDelimiters([Column1], "(", ")"), type text)
in
    #"Inserted Text Between Delimiters"[/SIZE]