Hello everybody,

I have a list (starting from A1) which items are separated by "/".

This list is 50 lines long. There are many items but I need to extract only the characters between the first 2 "/". What comes before and what is after can be deleted.

Sometimes it can happen that there is only 1 "/" followed by the letter "N". In this case I don't need to extract anything as N = Nothing.

Also I would like to avoid doubles.

Is there a way to create a macro that can do this?



Thank you all