Hello,
I like to extract 8 characters from a string in cell X. Strings are different lenght but last 10 chars ale always 10. I need 8 chars before last 10.
example string and what I need to extract (in bold)
random_name_some_data-123456782017121299P
Please help :)
Best Regards
W.