I tried it with 1325 in Column A, but as I said, when array entering, it
comes up with an error, and highlights the TEXT portion. I don't know this
formula at all, so I abide by your superior knowledge. Since I copied and
pasted, I don't see how I could have made an error on my side. Maybe just
check it on Excel when you get a chance

"Alan" wrote:

"Kassie" wrote in message
...

Hi Alan,

Your formula stops at the first occurence of
("1:"&LEN(TEXT(A1,"@")))), indicating that there is an error in the
formula. Maybe you should recheck it?


Hi Kassie,

It looks okay to me.

Perhaps it has a problem with a specific input in A1?

If you highlight a section of the formula in the formula bar such as
("1:"&LEN(TEXT(A1,"@"))) it should evaluate just that section of the
formula allowing you to debug for whatever is causing it to error.

That particular section shoudl evaluate to "1:4" as an example (if you
put a four digit number in A1).

I am not at a PC with excel right now, so I cannot try it, but I have
to admit I only tested it on 4 digit numbers so there could be a
problem with longer or shorter ones.

HTH,

Alan.