I have text in this format:
Filename , Pages:[1-4 digit number]/Rows:[1-4 digit number], Format, From: Name
The text is in A1 and I need to extract the 1-4 digit number in between the first colon and slash into B1 and the 1-4 digit number in between the slash and second colon into C1.
Any help would be highly appreciated. Thank you.
Filename , Pages:[1-4 digit number]/Rows:[1-4 digit number], Format, From: Name
The text is in A1 and I need to extract the 1-4 digit number in between the first colon and slash into B1 and the 1-4 digit number in between the slash and second colon into C1.
Any help would be highly appreciated. Thank you.