I have a long list of items in Column A that includes a code and descriptive text. I need to separate the code from the text description.
<ABC,1122, A1> - This is the text description
The formatting is always the same, except for the number of letters in the code, so I can't simply use the
LEN function. I'm trying to put the code (in brackets) into column B and the text "This is..." in column C.
Any ideas on how I can go about separating this long list?