cell 60 character max count in Excel

Hi,

I need to reduce the titles on our website to 60 characters and have the facility to export all titles in a csv file to import into excel.

Does anyone know of a facility in Excel which can filter out a list of cells/rows which have 60 or more characters.

thanks in advance.
jecommeraAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
barry houdiniConnect With a Mentor Commented:
You could do a count in a spare column, e.g.

=LEN(A2)

and then filter/sort by that column

regards, barry
0
 
BusyMamaCommented:
I don't know how to filter with just that column, but if you can put a column in which counts the length of the cell

=LEN(CellReference)

Then you could easily sort and filter out anything larger than 60.
0
 
BusyMamaCommented:
Sorry, Barry!  My refresh must be slow.  :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.