Hello.
I have the pinterest board links in my excel doc.
For example: http://pinterest.com/lejugedesegrais/doorways/
http://pinterest.com/luccasoares/in-out/
I want to remove the board names and leave only user names. Like this http://pinterest.com/lejugedesegrais/

I use this formula: =LEFT(A1,LEN(A1)-FIND("/",A1)) It works for such links: http://pinterest.com/lejugedesegrais/
but if the link contains character "-" it doesn't work and leaves http://pinterest.com/luccasoares/i

Can any one help me in this formula? your help is very appreciated. Thank you in advance