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


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



Add on question


how to get 202202 for above example?

0 Replies