Excel: Extract text after specific char in a string

HI Probably simple I just cant figure it out. I have cell content of a variable length string and I need to extract all text after "///" an example is below:

[TR] [TD="width: 604"]744/I/373632///SUVARNA, VINOD K MD=20110926 231597 Again I need to pull everything after the "///" Right, Left, and Mid wont work since the position is different any thoughts?
897/C///Amarnath Leena CD20110316 09105348
I need to pull everything after the "///" Another example would be: [TABLE="width: 604"]
[/TD] [/TR] [/TABLE]

This question generated 61 answers. To proceed to the answers, click here.

This thread is current as of July 24, 2012.

For more resources for Microsoft Excel