How to extract excel cell address from formula

[Sudip_inn]

var myString1 = "=D6/D2";
var myString2 = "=A6/Z2-1";
var myString3 = "=(X6/B2)-5";
var onlyLetters1 = myString1.Where(Char.IsLetterOrDigit).ToList();
var onlyLetters2 = myString2.Where(Char.IsLetterOrDigit).ToList();
var onlyLetters3 = myString3.Where(Char.IsLetterOrDigit).ToList();

suppose above code does not work. see the above code there is cell address like D6 or D2 etc. now how can i extract cell address from formula if the formula is simple or complex.

i want to store cell address in List<String>

please guide me. thanks

Continue reading...