Hi,
I have a few hundred cells which all have 4 digits in them seperated by a space.
Eg Cell A1 has 4 16 23 43 in it. Cell A2 has 5 78 76 45 in it.
What I want to do is have formulas in Columns B,C and D which extracts each number out
So cell B1 would have 4 C1 would have 16 and so on.
I have the formula to return the number at the start and at the end of the cell but would anyone be able to help me on what the formula would be for the middle 2?
Also i cant use text to columns here.
thanks in advance
I have a few hundred cells which all have 4 digits in them seperated by a space.
Eg Cell A1 has 4 16 23 43 in it. Cell A2 has 5 78 76 45 in it.
What I want to do is have formulas in Columns B,C and D which extracts each number out
So cell B1 would have 4 C1 would have 16 and so on.
I have the formula to return the number at the start and at the end of the cell but would anyone be able to help me on what the formula would be for the middle 2?
Also i cant use text to columns here.
thanks in advance