My First Blog

Hi I am starting this blog as a way for people to post questions on Excel. I work in finance and enjoy solving MS Excel questions...

Today's question of the day:

"How do I sort a column by text length?"

Solution:

The =Len(A1) function allows you to display the size of any particular cell. So you place this formula in a column next to your text with the A1 being replaced with the cell you want to measure. You can then sort by this column.

I will try to post as much as possible. Please leave questions.