Thanks but I can't get it to work. I don't think TRIM works within a COUNTIF
formula.
--
Traa Dy Liooar

Jock


"Stefi" wrote:

=COUNTIF($A$1:$A$700,TRIM(A1) )

Regards,
Stefi


€žJock€� ezt Ã*rta:

With =COUNTIF(A1:A700,A1) in cell B1 and copied down, entries which have a
space after the final letter are, quite correctly, treated as a different
word and therefore not included in the total for a particular word. IE:

[testing] and [testing ] are treated as different words. (brackets to show
the space)
How can I adapt the formula to ignore any space after the final letter in
the cell?

Thanks,

--
Traa Dy Liooar

Jock