Copy the formula from the formula bar and paste it here into the newsgroup
so that we can see what you are trying.
--
David Biddulph

"Andrea" wrote in message
...
I beg you pardon. Error reply is "#NAME!" and not "#NUM!".



"Andrea" wrote:

Hi Lars,
before all, thanks for your kind help.
I try to put this formula, skipping the "NOT(ISBLANK(", because in my
sheets
data are without spaces, but the result is "#NUM!" reply.
I checked well the commands as you give to me, but something doesn't like
to
excel. Have you an idea what kind of problem may occured having this
reply ?
Thanks again.

Andrea.