MID: Extracting each number their respective category

Hey,

You needed the 1st, 3rd, 5th etc character.
I thought about it a minute and decided the formula would be
2x +1 with increasing values of x starting with zero.

The Column() returns the column the formula is in. You started in Column D So that was the 4th column over.

So 2x + 1 turned into 2 times (Column() - 4) plus 1

I put this formula above into the Mid formula to pick off the 1, 3, 5, etc characters in the string.

thanks again!

Originally Posted by MarvinP

Hey,

You needed the 1st, 3rd, 5th etc character.
I thought about it a minute and decided the formula would be
2x +1 with increasing values of x starting with zero.

The Column() returns the column the formula is in. You started in Column D So that was the 4th column over.

So 2x + 1 turned into 2 times (Column() - 4) plus 1

I put this formula above into the Mid formula to pick off the 1, 3, 5, etc characters in the string.