Creating 2 columns from a delimiter but keeping delimiter

[LexiC]

How can I split columns based off of a number and letter. Ex: w(1999) or a7897

I need a new column between the w and (1999) and a and 7897. 

I tried text to columns but its removes the delimiter. 

[binuacs · Accepted solution]

@LexiC use the string functions