vbachanger
New Member
- Joined
- Sep 15, 2021
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
MaybeExcel Formula:=MID(A1,3,FIND("^",SUBSTITUTE(A1,"/","^",2))-3)
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1:C2 | C1 | =MID(A1,3,FIND("^",SUBSTITUTE(A1,"/","^",2))-3) |
GreatJust change the "^",2 to "^",3