Collecting numeric infromation from string

Hi all,

I have a string that looks like this: TaskName-UnitNumber-OrderNumber, e.g TaskName-1-1

The numeric values may change. e.g: TaskName-2-2, TaskName-10-98

I need a fairly simple function that would return the Unitnumber and the Ordernumber from the string.

Has anybody some ideas?

Cheers

Say your TaskName-2-2 is in cell A1. You would put =Unitnumber(A1) in any cell like B1. =Ordernumber(A1) in any cell like C1

Please Login or Register  to view this content.

If you need to to return both in the same cell

Please Login or Register  to view this content.

Thanks stnkynts

This is brilliant. I just ran this to see how it worked. I didnt know about split but I will now look into it.

Take a rep for the response.

cheers