Check Alphabetical Order in cell

[vinodbombale]

Hello,

I have Chemical name data in column Each chemical name is separated by "&" in cell.

I want a workflow for highlighting those records in which chemical names are not arranged alphabetically in a cell.

Eg 

ACETYLSALICYLIC ACID & CAFFEINE & CODEINE & PARACETAMOL

ACETYLSALICYLIC ACID followed by CAFFEINE then CODEINE & then PARACETAMOL.

In above example chemical names arranged in correct order.

Number of chemicals names present in cell is not fixed. Please refer attached file for workflow development.

[Emil_Kos · Accepted solution]

Hi @vinodbombale,

I have prepared a workflow for you that will show the incorrect alphabetical order.

[KarolinaRoza]

Hi @vinodbombale 

please find attached workflow, as I see it is quite similar to Emil's one 🙂

I added column with the comment if it is "Non-Alphabetical-Order" or "Alphabetical-Order".

I hope any of those workflows work for you.

Regards,

Karolina