Good morning,
I have a concatenation of unique identifiers, separated by commas, in column A. I have a formula in Column B which is as follows: =LEFT(A1,FIND(CHAR(1),SUBSTITUTE(A1&",",",",CHAR(1),2))-1) which identifies the first two unique identifiers in A:
A: 01,02,03,04,05
B: 01, 02
What I'm having trouble with is creating a =MID in C to identify the third and fourth identifier concatenated in A. I've got:
=MID(A1,LEN(B1)+2,???) where ??? is the num_chars that I'm having trouble defining. I thought that by repeating the exercise in column B but using the length of B (+2) as a starting point, the formula would count the next two identifiers- but thus far I've only been able to get that to literally count the length of B (+2) as the number of characters. This is an issue because the unique identifiers will not all be a consistent number of characters.
I'm hoping someone smarter than myself can point me in the right direction. Any thoughts/comments would be appreciated.
Thank you,
Jonathan
I have a concatenation of unique identifiers, separated by commas, in column A. I have a formula in Column B which is as follows: =LEFT(A1,FIND(CHAR(1),SUBSTITUTE(A1&",",",",CHAR(1),2))-1) which identifies the first two unique identifiers in A:
A: 01,02,03,04,05
B: 01, 02
What I'm having trouble with is creating a =MID in C to identify the third and fourth identifier concatenated in A. I've got:
=MID(A1,LEN(B1)+2,???) where ??? is the num_chars that I'm having trouble defining. I thought that by repeating the exercise in column B but using the length of B (+2) as a starting point, the formula would count the next two identifiers- but thus far I've only been able to get that to literally count the length of B (+2) as the number of characters. This is an issue because the unique identifiers will not all be a consistent number of characters.
I'm hoping someone smarter than myself can point me in the right direction. Any thoughts/comments would be appreciated.
Thank you,
Jonathan
Last edited: