Extracting First world from URL string

[sumantamsp]

Hi Friends,

In excel i want to extract the first word (without slashes). How can i do it? Thanks

/m/single.php?xxxid=3333&category=salt
/mobile/sony-a336-ny-hd-xxx2337
/mobile/sony-a330-ny-2-xxx2314

I want to extract the bold words

Please help me. I am new to excel

Thanks

[Pepe Le Mokko]

Data - Text to columns - Use / as delimiter - Select not to import the second column in the last window of the wizard

[sumantamsp]

Thanks a lot Pepe Le Mokko! You solution is very easy and practical

It can also be done using formula
=MID(A3, FIND("/",A3)+1, FIND("/",A3, FIND("/",A3)+1)-FIND("/",A3)-1)

A3 is the string cell