Extract text between MULTIPLE parentheses in one cell

[broncos347]

I am using the following formula to extract text from between two sets of parentheses in a cell and this works well, the formula does what it should do but is there a way that the blank spaces in the result can be removed as part of the formula?

Norwich Crown Point Depot Asset List - M&E and BS 2022 - DRAFT Client Issue.xlsx
	J	K
5	Block Title	helper 1.5
6	Access Route (09 01) Location (00 01)	09 0100 01
Asset Template

Cell Formulas
Range	Formula
K6	K6	=CONCAT(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE(J6,")","("),"(",REPT("(",1000)),SEQUENCE(LEN(J6),,,2)*1000,1000),"(",""))

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

Simplest solution is to wrap your formula in another substitute to get rid of the spaces.