i have applied formula to separate first and middle and last within special characters in cell
here middle name not extracted full i have applied formula like this
here middle name not extracted full i have applied formula like this
Cell Formulas | ||
---|---|---|
Range | Formula | |
B14:B15 | B14 | =LEFT(A14,FIND("/",A14)-1) |
C14:C15 | C14 | =MID(A14,FIND("/",A14)+1,LEN(A14)-FIND("-",A14,FIND("/",A14)-1)) |
D14:D15 | D14 | =RIGHT(A14,LEN(A14)-FIND("-",A14,FIND("-",A14)-1)) |