Add space before bracket

[HW1]

I have a column with names as  'BP Connect Ascot(WA)' and correctly as ''BP Bathurst (Stewart St)' 

I want them to be consistent with a space before the bracket like 'BP Connect Ascot (WA)' and ''BP Bathurst (Stewart St)' 

How can I do that?

Thanks

[Qiu]

@HW1 

Like this?

[HW1]

That is not the solution I am looking for as I have 'BP Bathurst (Stewart St)' coming in correctly which will turn out to 'BP Bathurst  (Stewart St)' Which is not what I want.

[MarqueeCrew]

Regex_Replace([field],"(.*\S)(\(.*)",'$1 $2')

[HW1]

It is doing nothing

[Qiu · Accepted solution]

@HW1 
Sorry. I misunderstood. This should work.