New Board : truncated formulas

[Andrew Fergus]

Hi

I believe formulas using the '<' and '>' without spaces around them are being truncated.

Whilst this can be easily resolved by inserting spaces into your formulas (using code tags doesn't seem to make any difference) unfortunately I think it has destroyed the meaning of a number of old posts.

Take for instance this gem from hady :
http://www.mrexcel.com/forum/showpost.php?p=1107631&postcount=14

That was not the original formula and the solution is now useless to others. For instance, if you try entering the formula I used in this thread as you would normally, it would appear like this:
=IF(IF(ISERROR(LEN(C2)),0,LEN(C2))< LEN(B2)*2,MID(B2,LEN(B2)-IF(ISERROR(LEN(C2)),0,LEN(C2)/2),1)&"."&IF(ISERROR(C2),"",C2),C2)

=IF(IF(ISERROR(LEN(C2)),0,LEN(C2))< LEN(B2)*2,MID(B2,LEN(B2)-IF(ISERROR(LEN(C2)),0,LEN(C2)/2),1)&"."&IF(ISERROR(C2),"",C2),C2)

Andrew

 

[Andrew Fergus]

Now that is Sod's/Murphy's law isn't it? When I was replying to the thread per my previous post it took me about 5 goes just to get the formula in and here I make post on the subject and everything works just fine!

So if I try again?
=IF(IF(ISERROR(LEN(C2)),0,LEN(C2))< LEN(B2)*2,MID(B2,LEN(B2)-IF(ISERROR(LEN(C2)),0,LEN(C2)/2),1)&"."&IF(ISERROR(C2),"",C2),C2)

Edit : D'Oh! Where is the rhyme or reason?

Also, the point still stands that some formulae in older threads have been altered.

Cheers
Andrew

 

[Von Pookie]

Well--it's not exactly a *new* problem. The same thing happened with the previous board software, too.

 

[BAlGaInTl]

If something looks truncated to me, I will just "quote" the message temporarily to see the original text.

It isn't ideal, but it works.

And of course, not every user that searches for an answer will think of that.