I have a column of data in one of the following 4 formats:
n (n) eg: 6 (1)
nn (n) eg: 17 (3)
n (nn) eg: 8 (13)
nn (nn) eg: 15 (12)
I want to separate the two elements into 2 columns and convert from text to number format. Using the first eg above the two elements would be 6 and 1.
I'm trying copying columns and then using find and replace with wildcards but struggling. Any help genuinely very gratefully received.
Bookmarks