I am writing to seek help, in creating a simple macro which can trim string in column A, by starting from the right-side and trimming the anything before the first space and displaying the output (string before the space - starting from the right-side) in column B.

I have attached an example file below, showing the input string in sheet1 and desired output is shown in sheet2 of the file.
test_1.xls

Please note:My actual dataset is more than 200,000 records.

Many thanks for your time and help.