Excel: Extracting a number in between characters


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.


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of June 04, 2015.


For more resources for Microsoft Excel