Data filter HELP!

  • Thread starter Thread starter McRibIsBack
  • Start date Start date
M

McRibIsBack

I'm using Excel '03 and I have two columns with data, A & B. Column A holds
the name of a letter and Column B stores the body of the letter. When I
apply a Data Filter to these two columns, it isn't working. For instance, I
have about 30 letters that have the word "seven" in them, but when I do a
"Custom - Contains - seven" in Excel '03, it only shows 2 items.

I had someone who has Excel '07 try it, and it shows all 30 items. There
are approximately 607 letters/rows on this sheet.

Does anyone have any idea what the issue is?

Thanks!
 
It turns out, the cells have to be in text format...BUT, the cells contain
over 1,024 characters, which excel then displays as ######## etc. and no
formatting seems to remove that.

I used this formula to convert it to text and it worked: =""&A1, =""&B1 etc.
 
Back
Top