Need to get cell adress

I need to split the cell address alphabet value
Eg:A11 output should be A and AB11 output should be AB

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(yourString,"^[A-Z]+").Value

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.