Left & Right Formula To Show Number Not/as Well

Re: Left & Right Formula To Show Number Not/as Well

Barryj,

I don't see exactly what you mean.

I entered in d9 the following formula ( it is written in German but shouldn't be any problem to translate in English

D9:=WENN($C$15<=18;LINKS(D8;WENN(ISTFEHLER(FINDEN("/";D8;1));99;FINDEN("/";D8;1))-1);RECHTS(D8;LÄNGE(D8)-WENN(ISTFEHLER(FINDEN("/";D8;1));0;FINDEN("/";D8;1))))
( I provide a first translation - hopfully is the right one; BTW separators could be "," instead of ";" )
D9:=IF($C$15<=18;LEFT(D8;IF(ISERROR(FIND("/";D8;1));99;FIND("/";D8;1))-1);RIGHT(D8;LEN(D8)-IF(ISERROR(FIND("/";D8;1));0;FIND("/";D8;1))))

it looks to me to cover all your cases. Or am I missing something?

filippo

Re: Left &amp; Right Formula To Show Number Not/as Well

And no thanks to you Barryj for ignoring my posts, which leaves future readers in doubt!