Help Needed - Formula

  • Thread starter Thread starter zimmeml2
  • Start date Start date
Z

zimmeml2

I need a formula that will count the TOTAL number of characters in an
individual cell - that can then be applied to a range of cells to find
all cells that contain more characters than a specified number.


For example, we need to search approx. 80,000 records to find all cells
that contain more than 25 characters.

We are working in Excel 2000.

Any help would be greatly appreciated!
 
Use the LEN function.

HTH
Jason
Atlanta, GA
-----Original Message-----

I need a formula that will count the TOTAL number of characters in an
individual cell - that can then be applied to a range of cells to find
all cells that contain more characters than a specified number.


For example, we need to search approx. 80,000 records to find all cells
that contain more than 25 characters.

We are working in Excel 2000.

Any help would be greatly appreciated!


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
Hi

If you want it in one step you could use

=LEN(A2)>25

This would give you a TRUE or FALSE

Andy.

zimmeml2 said:
I need a formula that will count the TOTAL number of characters in an
individual cell - that can then be applied to a range of cells to find
all cells that contain more characters than a specified number.


For example, we need to search approx. 80,000 records to find all cells
that contain more than 25 characters.

We are working in Excel 2000.

Any help would be greatly appreciated!


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Adding one final approach to get your final answer:

1) Enter a formula such as this =SUM(IF(LEN(A1:K500)>24,1,0))
(Note it will return an #Value error)

2) Make it an array formula by:
a) Edit the formula {F2}
b) While in edit mode press {Ctrl}+{Shift}+{Enter}
 
Back
Top