How do you remove all text before the last forward slash?

Hey everyone,

Does anyone know a formula where you can remove all the text before the last forward slash?

For example; entry: Garden/Shed/Table/Ashtray and I would just like Ashtray!

Any help would be greatly appreciated, don't really fancy going through 3500 records manually!

Thanks very much for your time, any help would be greatly appreciated,

Luke

I'd do it with a simple udf, but I'm rubbish at formulas:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

You may then use this formula like any other

wow, thanks so much for your quick replies - just trying them now, i'll let you know the results :-)

Thanks guys, I have tried the formula given by Special K and it works perfectly! Thanks very much for your response too Kyle123, although I haven't tried it (looks a little too complex for me atm) I'm sure someone will find this info useful,

all the best

Luke

OK no problem Kyle, I'm sorry about that :

here is a link to the other forum and was subsequently given another way to solve the problem:

=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",255)),255)) on http://www.mrexcel.com/forum/excel-q...ml#post3815738

sorry for my unintentional rebelism! I didn't expect such a fast reply and was trying to get a quick answer by spreading the love.

Have a great one, Luke

No probs
Ta muchly