BaconMcSandwich
New Member
- Joined
- Jun 14, 2021
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
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—
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—