Sort and Segregate text message

Pushpakumar,

With that updated information, here's an example formula to gather all of the "ALL" options from your list in any order that they occur in:
List(";",
If(Left(Part([TextFieldName],1,";"),1)="A",Part([TextFieldName],1,";")),
If(Left(Part([TextFieldName],2,";"),1)="A",Part([TextFieldName],2,";")),
If(Left(Part([TextFieldName],3,";"),1)="A",Part([TextFieldName],3,";")),
If(Left(Part([TextFieldName],4,";"),1)="A",Part([TextFieldName],4,";")),
If(Left(Part([TextFieldName],5,";"),1)="A",Part([TextFieldName],5,";")),
If(Left(Part([TextFieldName],6,";"),1)="A",Part([TextFieldName],6,";")),
If(Left(Part([TextFieldName],7,";"),1)="A",Part([TextFieldName],7,";")),
If(Left(Part([TextFieldName],8,";"),1)="A",Part([TextFieldName],8,";")),
If(Left(Part([TextFieldName],9,";"),1)="A",Part([TextFieldName],9,";")),
If(Left(Part([TextFieldName],10,";"),1)="A",Part([TextFieldName],10,";")),
If(Left(Part([TextFieldName],11,";"),1)="A",Part([TextFieldName],11,";")),
If(Left(Part([TextFieldName],12,";"),1)="A",Part([TextFieldName],12,";"))
)

That same pattern could be extended for the full amount of entries you anticipate could be in your data set. For the other two formula fields, change the A to either Y or N depending on which option you want to collect

------------------------------
Eric Mohlman
------------------------------