Count no of words between comman separated words

Datatable contains

A,b
A,c,b
U,k,p,j

Expected result
A,b

As it has only 2 letters

My req is to fetch the row which has least no of letters

Hi…
@RachelN use split function to split the words and count it how many times it was occurred…test.xaml (7.4 KB) Monthly.xlsx (8.2 KB)

1 Like