Remove Spaces at the end of text

[BaconMcSandwich]

I need a way to remove the trialing spaces at the end of some alpha numeric text strings.
However the strings are random lengths, sometimes ending in numbers, sometimes letters, and sometimes include double spaces within the string. All this needs to be kept the same but the end spaces removed.
(Annoyingly I found a simple formula to do this and didn’t save the info ?‍)

Below are some rough examples with spaces replaced with dashes. It’s just the trialing spaces that need removing, everything else needs to stay.
String examples:
AU12H17-AJDM—1——
AU12USUHWIJS———
AU12IWJ—-IJ12M—

 

[Marc L]

​

You can use the TRIM worksheet function …​

 

[BaconMcSandwich]

​

You can use the TRIM worksheet function …​

Trim will remove the double spaces in the middle of the strings. Which I don’t want to happen.
This is the problem as almost every search suggest trim.

 

[Fluff]

You could use a UDF

Function Bacon(Cl As Range) As String
   Bacon = RTrim(Cl)
End Function

+Fluff 1.xlsm
	A	B
1
2	abc 123	abc 123
3	AU12H17 AJDM 1	AU12H17 AJDM 1
4	AU12USUHWIJS	AU12USUHWIJS
5	AU12IWJ IJ12M	AU12IWJ IJ12M
Main

Cell Formulas
Range	Formula
B2:B5	B2	=bacon(A2)

 

[FormR]

Here's another option you could try.

=LEFT(A1,MAX(IF(MID(A1,SEQUENCE(LEN(A1)),1)<>" ",SEQUENCE(LEN(A1)))))