I am trying to extract a string of alpha/numeric characters. The string always begins with a "L", but the subsequent characters could be various lengths. For instance, A104LCRTI1 would be the cell and I would want to extract the "LCRTI1". I tried the function =right(cell,6), but the problem is that the number of characters after "L" could vary with each cell. Does anyone know how to extract the string of characters beginning with the "L" that have varying character lengths after the "L" and return the string starting with the "L"? I am working with a 49,000 line spreadsheet so some assistance would be appreciated. Thanks!