Hello Bob,
A. In my example -CL/N is taken from an email. So if /N or /n is encountered then excel can simply skip it
B. Both lower and upper case must be treated the same way
C. N is never going to be the data itself because it represents an empty space
D. No, there is never such a case
E. "-DR/" cannot exist. It must either be followed by "N" or the other string. That is mandatory.
If you think that Split is my best bet, can you please write me an example of it? how do I write it in, lets say, cell B1 if the data I am looking for in in A1? Further to that, the strings where I need to extract the data, are in cell A1:A45, and I need the results to be in B1:B45
Thanks for your patience
Last edited by s7y; 06-04-2013 at 05:50 PM.
Reason: better question
|