View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Finding cells of different string length.

Where is the string length stored?

To find the length of a cell A1, for example, use =len(a1). Then compare
this to the string length.

Regards,
Fred.

"kingie" wrote in message
...
Hi,
I have a large table of data that is used to print random codes. The data
is
started as an excel file which is then changed to notepad due to the large
quantity of codes. The ink jet printer that extracts the code uses the
string length to know where it starts and finishes each code. If there is
a
cell with the wrong string length the whole thing goes out of sync. How
can I
search the data for cells containing the incorrect string length.