Roger,

Ah, that's why you are the expert. (I laughed at my formula after I have seen yours.) I am glad I posted and you responded. Lately, I have been learning about CHAR and I am attracted to it while I have forgotten the simple things in life. g I thought I needed REPT to catch all. I read an example of *adding* trailing spaces and REPT is used. Is it true that we need REPT when adding trailing spaces?

Thank you for helping me all the time. By the way, have you read my post about using PivotTable to check for duplicates?

Epinn

"Roger Govier" wrote in message ...
Absolutely no difference to the much simpler
=SUBSTITUTE(A1," ","")

--
Regards

Roger Govier


"Epinn" wrote in message
...
This is how I would remove trailing spaces.

=SUBSTITUTE(A1,CHAR(32),REPT("",255))

Please correct me if I am wrong. Thanks.

Epinn

"Epinn" wrote in message
...
The formulae discussed in this thread should serve Bob's needs.

Experts, please confirm that the formulae are only good as long as there
are no trailing spaces.

e.g. AA111 and AA111__ ( __ are trailing spaces) will be counted twice.

If we are really picky, we'll do LEN( ), SUBSTITUTE ( ) etc., right?

Epinn

"bob" wrote in message
...
I have a column with the following dates:

11/23/05
11/23/05
11/23/05
11/25/05
11/25/05
11/28/05
12/1/05
12/1/05
12/1/05

I want a formula that will tell me how many unique dates there are in
the
column. Can anyone help?

thanks,
Bob