Most valuable professional
  • Hot Topics

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: 897/C///Amarnath Leena CD20110316 09105348 I need to pull everything after the "///" Another example would be: 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?

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel