Most valuable professional
  • Hot Topics

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 4, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel