Seperate date by symbol?

[khaos]

Hi

I'm trying to figure out a formula that will seperate by symbol, specificlly "/"
----------------------
IE
Original cell data

Rear Sprocket/Urban Industries/ (Bolt Cirlce-6 Bolt;Bolt Hole Diameter-;Hub ID-)

Resulting cell data

Rear Sprocket/Urban Industries

----------------------
I want it to keep the words "Rear Sprocket" / and the following company name while disguarding everythign else including the second "/"

I may be a bit confusing i'm sorry please take a look at my sample file

Thanks again!

[khaos]

Just follow these simple steps

:http://blogs.msdn.com/lauraj/archive...08/177965.aspx

Works great incase anyone needs it

Thanks for looking

[VBA Noob]

Hi,

Try the below and drag down

=LEFT(A3,LEN(LEFT(A3,FIND("/",A3,FIND("/",A3,1)+1)))-1)

VBA Noob

[khaos]

yap that seems to do the job too! thanks!!

[VBA Noob]

Glad to here it

VBA Noob

[daddylonglegs]

=LEFT(A3,LEN(LEFT(A3,FIND("/",A3,FIND("/",A3,1)+1)))-1)

looks a bit complicated to me, why not just

=LEFT(A3,FIND("/",A3,FIND("/",A3)+1)-1)

[VBA Noob]

You know me Daddylonglegs.....If there's a hard way I can find it

VBA Noob

[khaos]

Well is there an easy and a hard way to figure this one out?

http://www.excelforum.com/showthread.php?t=584883

thanks guys