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)

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Column1[/td][td=bgcolor:#70AD47]Text Between Delimiters[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]01. First Week (1)[/td][td=bgcolor:#E2EFDA]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]None (1)[/td][td]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]10/09/2018 (1)[/td][td=bgcolor:#E2EFDA]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Initial Onboarding Complete[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]01. First Week (1)[/td][td=bgcolor:#E2EFDA]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]None (1)[/td][td]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]07/30/2018 (1)[/td][td=bgcolor:#E2EFDA]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Initial Onboarding Complete[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]01. First Week (1)[/td][td=bgcolor:#E2EFDA]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]None (1)[/td][td]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]10/09/2018 (1)[/td][td=bgcolor:#E2EFDA]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]First Week Onboarding Complete[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]01. January (2)[/td][td=bgcolor:#E2EFDA]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]None (2)[/td][td]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]03/12/2018 (2)[/td][td=bgcolor:#E2EFDA]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SolidFire 4805 Support Renewal[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Amtelco Infinity Support Renewal[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]01.03.2019 (5)[/td][td]

5​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]None (5)[/td][td=bgcolor:#E2EFDA]

5​

[/td][/tr]
[/table]

[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]