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