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...
I use Charles Williams's FastExcel and his function rgx.MID worked well with your RegEx.
= Rgx.MID(Table1, "[A-Z]{3}\d{4}")
dear Peter i am using office 2019 and I need to to appreciated to send me a document how to write the proper query that i can write directly from A to Z because the last solution you sent me whenever i goto power query it's telling me that the i cannot use the solution within my excel power query because the reason above.
i am very appreciate yours efforts in advance.