Removing Trailing Characters in a String

[DrDebit]

I have columns of items. Some rows have 2 or 3, but some rows have 7 or 8, and everything in between. I merge all of the columns into one, each element separated by a semi-colon. However, some lists have several semi-colons strung together at the end. Is there a function, like the Text.TrimEnd function for spaces, that will eliminate semicolons at the end? Thank you so much!

 

[Yongle]

This sounds like a standard Excel question but is in the Power BI forum
(so this may not help)

One formula to try
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"; ","@@"),";",""),"@@","; ")

 

[Yongle]

Concatenating Text

Office 365 has function TEXTJOIN which allows concatenation with a delimiter ( "; " ), ignoring empty cells (TRUE/FALSE)

=TEXTJOIN("; ",TRUE,A1:J1)

With these values in any of the cells A1:J1:
Green Tomatoes
Goat
Cheese
Basil
Red Peppers

Formula returns:
Green Tomatoes; Goat; Cheese; Basil; Red Peppers

 

[sandy666]

Text.TrimEnd(text as nullable text, optional trim as any) as nullable text

Text.TrimEnd([ColumnWithText],";")