I have a set of strings:
Building_Level_SpecificNumber Name
B_01_16 Wachschutz
and need to extract each part. Here I need = 16. Here is code I manage to get:
Building:
=IF(C10>0,LEFT(C10,FIND("_",C10)-1),0)
Level:
=IF(C10>0,LEFT(MID(C10,FIND("_",C10)+1,256),FIND("_",MID(C10,FIND("_",C10)+1,256))-1),0)
- Specific number: - not solved yet
- Name:
=RIGHT(C10,LEN(C10)-SEARCH(" ",C10))