This is what I tried. Replaced ] with #$ and the , with ; =RIGHT(CELL("filename",A1);SUM(LEN(CELL("filename",A1))-SEARCH("#$",CELL("filename",A1);1)))