For the easy part:
To delete the characters to the left of the "/" and the following blank,
select the cells, then use Tools - Text to Columns...

specifiy both the "/" and the blank as delimiters. You will end up with two
columns neatly split by "/ ". Throw away the part do don't need.

The other part requires more than a Student
--
Gary's Student


"Kyle" wrote:

I have two lists in a workbook, each on there own sheet. I want to find if
the value of on cell in list "A" has an exact match in list "B". Also how
can I strip all characters preceding the character "/" in a cell and also
remove the space that is right after the character "/"?