How to create this cool text effect in photoshop?

A »Hard Mix«-Pattern Layer could also be employed. 

A Pattern Layer set to Blend Mode »Hard Mix«, Smart Filters and some painting could also be employed. 

Try a text layer and a noise layer both set to dissolve and paint on masks to create the moving sand.
 

Dave