 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
05-19-2008, 03:08 PM
|
|||
|
|||
|
Count Characters in Field
Is there a way to do a search for all fields that contain more than 1000
alphanumeric characters? -- Brandon http://www.PresentationsDirect.com 
|
|
05-19-2008, 03:31 PM
|
|||
|
|||
|
Re: Count Characters in Field
Found it . . . Insert a formula like =Len(a1) in a separate column and then
sort by that column to see the characters. -- Brandon "Brandon" <bsmith@presentationsdirect.nospam.com> wrote in message news:O%23AsXnbuIHA.4952@TK2MSFTNGP05.phx.gbl... > Is there a way to do a search for all fields that contain more than 1000 > alphanumeric characters? > > > -- > Brandon > http://www.PresentationsDirect.com >
|
|
05-19-2008, 03:36 PM
|
|||
|
|||
|
Re: Count Characters in Field
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 On May 19, 3:08*pm, "Brandon" <bsm...@presentationsdirect.nospam.com> wrote: > Is there a way to do a search for all fields that contain more than 1000 > alphanumeric characters? > > -- > Brandonhttp://www.PresentationsDirect.com
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
