Want to know how to extract specific characters in excel by using formula

Visitor

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?

0 Replies