# Left & Right Formula To Show Number Not/as Well

• Re: Left &amp; 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

( 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

Thanks guys for the help on this, problem now solved, thanks Filo65 your formula worked fine, thanks again for the help.

• 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!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!