Forum Discussion
Sort function
A quick solution would be to add an additional column with the formula...see attached file.
to find Text
=LEFT(A3,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A3&"0123456789"))-1)
to show result
=IF(B1=""; "Incorrect";"Correct")
Hope I could help you with these information.
I know I don't know anything (Socrates)
This has possibilities, however it is complicated by the fact that some of the serial numbers without SN prefix are actually genuine serial No's for other non-related units ( i would need to look at the complete dataset to determine this however ) I think it would be too complicated to work out criteria to distinguish between them, but i think this could be a good starting point.
It is not dependent on the letters...if letters then correct, if not then incorrect...any text.
Attached is the example in the file expanded with other letters...otherwise VBA would be an additional option.