I need to separate numerical digits from string of numbers and put them in separate cells (only last 5 numerical digits starting from right). If number has "x" between them than it must ignore it and go to the next number.
I have attached an image and also excel file to explain what I want clearly.
Column A is the input and output is from column B to F.
string.png
Bookmarks