REMOVEREPEATS

[RicoS]

REMOVEREPEATS removes chosen repeated characters from an array

=LAMBDA(array,repeatChar,
   LET(a,array,rpt,repeatChar,
      ttaA,TEXTTOARRAY(a),
      isMatch,--(ttaA=rpt),
      cA,COLUMNS(ttaA),
      rArr,RESIZEARRAY(RIGHTARRAY(isMatch,cA-1,0),,cA,0),
      isRepeat,1-(isMatch*rArr=1),
      rptCols,COLUMNNUMBERS(isRepeat)*isRepeat,
      srtRows,SORTROWS(rptCols,1),
      idx,IF(srtRows=0,"",INDEX(ttaA,ROWNUMBERS(srtRows),srtRows)),
      return,TEXTJOINARRAY(idx,,),
   return)
)

Lambda - Last Cell and Split.xlsx
	B
1	Original Array
2	test--this--removal--of---repeats
3	this--test--is---the-greatest---test--you'll--ever--see
4	further--test--to---prove-----that--I'm--serious
5
6
7	Text join
8	test-this-removal-of-repeats
9	this-test-is-the-greatest-test-you'll-ever-see
10	further-test-to-prove-that-I'm-serious
Sheet1

Cell Formulas
Range	Formula
B8:B10	B8	=REMOVEREPEATS(B2:B4,"-")
Dynamic array formulas.

 

[smozgur]

Alternatively, by using TRIM: (I learned that Excel TRIM function removes extra spaces from @MrExcel for the first time in my life after creating SLUGIFY and SLUGIFY.PLUS functions)

Lambda.xlsm
	B	C
1	Original Array
2	test--this--removal--of---repeats
3	this--test--is---the-greatest---test--you'll--ever--see
4	further--test--to---prove-----that--I'm--serious
5
6
7	SUBSTITUTE & TRIM	Also using LET to pass the delimiter once
8	test-this-removal-of-repeats	test-this-removal-of-repeats
9	this-test-is-the-greatest-test-you'll-ever-see	this-test-is-the-greatest-test-you'll-ever-see
10	further-test-to-prove-that-I'm-serious	further-test-to-prove-that-I'm-serious
Sheet4

Cell Formulas
Range	Formula
B8:B10	B8	=SUBSTITUTE(TRIM(SUBSTITUTE(B2:B4,"-"," "))," ", "-")
C8:C10	C8	=LET(delim,"-",SUBSTITUTE(TRIM(SUBSTITUTE(B2:B4,delim," "))," ",delim))
Dynamic array formulas.

 

[RicoS]

The above function utilises other LAMBDA functions, linked below:
TEXTTOARRAY
RESIZEARRAY
COLUMNNUMBERS
SORTROWS
ROWNUMBERS
TEXTJOINARRAY

 

[RicoS]

Alternatively, by using TRIM: (I learned that Excel TRIM function removes extra spaces from @MrExcel for the first time in my life after creating SLUGIFY and SLUGIFY.PLUS functions)

That's definitely superior! To be honest, I just needed something to use up all these LAMBDAs I've been creating. I have been using them a lot in other things too. I think the good thing to take out of these posts (for me anyway) is that others may (or may not) find the actual function of the functions useful. I don't expect my solutions to be the most optimal, but I've found a need for the basic ones like ROWNUMBERS() and so on for quite a few things, so hopefully others will too (and improve on them!).

 

[smozgur]

That's definitely superior!

I felt exactly the same when Bill showed me how TRIM removes the extra spaces right after I posted the SLUGIFY.PLUS that basically extends SLUGIFY to do what TRIM can do easily . Or Peter showed me that I don't need an array formula in the REVERSE function. This is all great!

And it is great what we are doing with Lambda samples. We are finding new ways and trying to learn/discover Lambda's capabilities, discussing the functions. I am sure these samples will also help the Lambda developer team to extend the function with new features.