Formula Query - to do with cutting text

[jbhakta]

Hi

I have lots of codes varying in lengh but all end with "/0 or "/1"

Like this

01N056242898659/0
01N050208449R0/1

I want a formula that with display the following


01N056242898659
01N050208449R0


Normally I would use "Text to Column" or the RIGHT n LEFT formula but I can not use it here because of the variation in number of characters.

I have 8000 lines of theses codes so a formula would cut down my time alot.

rgds

J.

 

[NBVC]

Try

=LEFT(A1,FIND("/",A1)-1)

 

[SteveO59L]

So, you just want to remove the "/" and anything following ?


=LEFT(E15,(FIND("/",E15)-1))

 

[jimbojones]

Hi there.

Use the =FIND() Finction. Something like:

=LEFT(A1,FIND("/",A1)-1)

Hope that helps,

James

 

[jbhakta]

Thats great, Thank you for your help

J.