Hello all,
I am new to excel, and have a question regarding extracting certain numbers from a cell entry.
For example, I have an entry that reads "(18-1-4) " (without the quote marks, and there is a space after the last bracket if that makes a difference). I need to put the numbers into seperate cells. The numbers range from 0 through to 200. So another example may look like "(200-50-100) ".
Is this possible?
Cheers.
I am new to excel, and have a question regarding extracting certain numbers from a cell entry.
For example, I have an entry that reads "(18-1-4) " (without the quote marks, and there is a space after the last bracket if that makes a difference). I need to put the numbers into seperate cells. The numbers range from 0 through to 200. So another example may look like "(200-50-100) ".
Is this possible?
Cheers.