HI.

I am trying to nest a MID argument into an Index Match formula. Basically, Index match isnt an issue, the returned value is a string of numbers in a cell seperated by "-" for example 1234-56-789-1234 I need to split the returned value into four cells as opposed to returning the complete value. Any suggestions on how i should go about this?

Thanks.