Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | 72653/m/17 | ***53/m/17 | ||
2 | 101371/f/17 | ****71/f/17 | ||
3 | 72673/m/17 | ***73/m/17 | ||
4 | 72653/mf/17 | ***53/mf/17 | ||
5 | 101371/f/171 | ****71/f/171 | ||
6 | 72673/mf/171 | ***73/mf/171 | ||
Sheet137 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =REPT("*",LEN(LEFT(A1,FIND("/",A1)-3)))&MID(A1,FIND("/",A1)-2,255) |
A | B | |
---|---|---|
1 | 72653/m/17 | ***53/m/17 |
2 | 101371/f/17 | ****71/f/17 |
3 | 72673/m/17 | ***73/m/17 |
4 | 72653/mf/17 | ***53/mf/17 |
5 | 101371/f/171 | ****71/f/171 |
6 | 72673/mf/171 | ***73/mf/171 |
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 72653 | m | 17 | ***53/m/17 | ||
2 | 101371 | f | 17 | ****71/f/17 | ||
3 | 72673 | m | 17 | ***73/m/17 | ||
4 | 72653 | mf | 17 | ***53/mf/17 | ||
5 | 101371 | f | 171 | ****71/f/171 | ||
6 | 72673 | mf | 171 | ***73/mf/171 | ||
Sheet137 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1 | =REPT("*",LEN(A1)-2)&RIGHT(A1,2)&"/"&B1&"/"&C1 |