Tuesday

  • Thread starter Thread starter JDay
  • Start date Start date
J

JDay

I have a spreadsheet where i need to count the number of the letter "T" in a
row. One row in particular however, will default to "Tue" as though I am
entering a day of the week. Subsequently, the totals column will not
recognize this cell and count the contents, even when I do backspace to get
just the "T" What am I doing wrong??
 
Say that cell is A1. In some blank cell enter "=Len(A1)" without the
quotes. If you get a number greater than 1 then you have spaces (probably)
before or after the T. You can remove the spaces manually or use a formula
like =Trim(A1). Post back if you need more. HTH Otto
 
Back
Top