Forum Discussion
andymaves1201
Mar 31, 2022Copper Contributor
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
Gov_Rep_Cli_Rep_BATCHREQUEST301_BATCH_20220312_110008_G1234_202202.xls
Add on question
how to get 202202 for above example?
No RepliesBe the first to reply