Count Characters in Field

  • Thread starter Thread starter Brandon
  • Start date Start date
B

Brandon

Is there a way to do a search for all fields that contain more than 1000
alphanumeric characters?
 
Found it . . . Insert a formula like =Len(a1) in a separate column and then
sort by that column to see the characters.
 
What do you mean by "search"?

LEN(A1) will give you the number of characters in A1, so you could put
this formula in a helper column:

=IF(LEN(A1)>1000,"Yes","")

and copy down. You can then apply autofilter to this column and select
Yes from the filter pull-down.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help creating Excel formula 1
Excel 4 characters alphanumeric data validation check on one excel column. 1
Cell with same number of characters 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
SUMIF with alphanumeric criteria range question 3
Data validation, mandatory and restricted field length for excel vbs 10
Count Dates? 5
Cell Formated for MAC address 2

Back
Top