Find 2 characters delete single space before and all chacters after

The example info below are contained in one single cell each in the same column and I need to find BG and then remove the single space in front of BG and remove all characters after BG

7 SD1 Ferguson Acocks 6 BG1953919 BLX CJ210 1360 3 14 27 1907.740 $0.00 $75.00 $100.00 $175.00
1603 BU518 Sarg Middle 28 CS16437 DK F737 1280 3 1 41 1902.56 $1.00 $56.00 $101.00 $155.00
1044 BU51 James Leigh 85 BG8239175 CH X8160 1730 3 18 27 1902.71 $4.00 $55.00 $110.00 $135.00

This would be the result:
7 SD1 Ferguson Acocks 6BG
1603 BU518 Sarg Middle 28 CS16437 DK F737 1280 3 1 41 1902.56 $1.00 $56.00 $101.00 $155.00
1044 BU51 James Leigh 85BG

Many thanks Ruth

Try this: =IFERROR(TRIM(LEFT(A1,FIND(" BG",A1)))&"BG",A1)

Thank you very much josephteh. Where do I set this post to solved?

You are welcome Ruth. At the top of your post #1 under Thread Tools.