Solved

cell 60 character max count in Excel

Posted on 2011-09-27
3
169 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:jecommera
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
Comment Utility
You could do a count in a spare column, e.g.

=LEN(A2)

and then filter/sort by that column

regards, barry
0
 
LVL 7

Expert Comment

by:BusyMama
Comment Utility
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
 
LVL 7

Expert Comment

by:BusyMama
Comment Utility
Sorry, Barry!  My refresh must be slow.  :)
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL INSERT error - Excel VBA/ADO/Access 2016 2 23
formattig excel from access 3 17
Convert .PDF 6 38
TT Status Chang 3 29
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now