Forum Discussion

Copper Contributor

Jun 04, 2019

Sorting Data in Excel

I am trying to sort my students' data by who needs remediation. Those that need remediation have a blank square while those that don't have a black square. I would like for those that need remediatio...

Final Data to sort.xlsx19 KB

BI & Data Analysis

excel

Formulas and Functions

TMaddox

Copper Contributor

Jun 05, 2019

ChrisMendoza

This spreadsheet was exported from a quiz website I use (Quia). How do I quickly change all the pictures to the alt symbols?

Thanks so much for your help!!

Teresa Maddox

ChrisMendoza

Iron Contributor

Jun 06, 2019

TMaddox -

Multi-select by CTRL + Left Click -> F2 -> ( ALT + 254 ) / ( ALT + 9 ) -> CTRL + Enter is how I did it. It was actually more time consuming to delete all the images in your small sample for myself.