Monday, 17 July 2023

Excel Sort values in ascending order using function TEXTJOIN

 Excel :: 


Text :: 1,3,5,2,9,5,11

Result ::

1,2,3,5,5,9,11

Formula ::    

TEXTJOIN(",",1,SORT(MID(SUBSTITUTE(A1,",",REPT(" ",100)),SEQUENCE(LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1,,1,100),100)+0))

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...