Forum Discussion
selecting specific characters (3capital letters and 4numbers from a row field in a column
Dear, I have an renumbers only from a request how to split a specific combination of 3capital letters and 4numbers from a columns below written in red color: 2G/HUAWEI/Region5/Samawa/BSAMH01/Wark...
For the pattern you show the Excel formula can be extracted with the formula
= TEXTBEFORE(
TEXTAFTER(data,"_"),
"-")That could be placed within a Lambda function to read
= RedString(data)where a meaningful name for whatever it is that you have extracted would be used in place of 'RedString'.
If you are importing the data then Power Query would allow you to build a more meaningful data table before it appears in Excel.