Mar 31 2022 01:39 AM - edited Mar 31 2022 01:44 AM
Hi community!
I want to extract these characters which locates between the last two"_".
I've tried various of formulas but failed ( i think is to get the characters between those two "_"), can anyone help for the formula? Thanks!
Example: I want to get G1234
Gov_Rep_Cli_Rep_BATCHREQUEST301_BATCH_20220312_110008_G1234_202202.xls
Add on question
how to get 202202 for above example?