Needing to get these 7 digit numbers on their own, thinking it's a combination of the Left and Right formulas
Number of characters is not constant so preferably wanting to trigger on the _ (underscores).
Any help greatly appreciated
<colgroup><col></colgroup><tbody>
</tbody>
If anything further needed to address, please advise.
Kind regards
Joel
Number of characters is not constant so preferably wanting to trigger on the _ (underscores).
Any help greatly appreciated
ABC_1010101_LOLL_A_Group1 |
ABC_1010301_LOLL_A_Group2 |
BBC_1010121_LOLL_A_Group3 |
ABC_1310101_LOLL_A_Group4 |
ABC_1010501_LOLL_A_Group5 |
ABC_1013101_LOLL_A_Group6 |
AAC_1014101_LOLL_A_Group7 |
ABC_1010181_LOLL_A_Group8 |
ABC_2010101_LOLL_A_Group9 |
ABC_6010101_LOLL_A_Group10 |
ACC_1010101_LOLL_A_Group11 |
ABC_1040101_LOLL_A_Group12 |
<colgroup><col></colgroup><tbody>
</tbody>
If anything further needed to address, please advise.
Kind regards
Joel