Help Needed - Formula

[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!

 

[Dan E]

Take a look at the LEN function

Dan E

 

[Jason Morin]

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!


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step

guide to creating financial statements

 

[Andy B]

Hi

If you want it in one step you could use

=LEN(A2)>25

This would give you a TRUE or FALSE

Andy.

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!

creating financial statements

 

[Charles Maxson]

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}

--
Charles
www.officezealot.com

Hi

If you want it in one step you could use

=LEN(A2)>25

This would give you a TRUE or FALSE

Andy.

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!


------------------------------------------------
[/url]


~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements