I have a string which may contain cell address, which is look like:
A1, B34, Z728 - only capital letters and
AA3, ABA92, ZABC83 - there may be several letters before Integer number.
The typical source string is look like:
=3+7*A1-B3*AB28
I need to get collection of all cells in the string: A1, B3, AB28
I tried to use Regex.Matches method with the following regular expression: @"[A..Z]+?[1..9]+?", but it doesn't work.
Can anybody help me to write the regular expression?