I have a column of data that starts with a name then has a parenthesis with text in it. Something like the below:
John Smith (ABC123)
I want to insert a column in PowerQuery that lists John Smith so data prior to the space and first parenthesis. Normally would use the LEFT function in excel but need help with the formula which would either be text.start or text.end in PQ to do this. Need this column added so I can merge with another query. Any help would be much appreciated.
Bookmarks