Cell A3 has the following link C:\user\rich\work\project\excel123.xls, with result 100

I want to find for cell
A1 => path: "C:\user\rich\work\project\"
A2 => filename: excel123.xls


I understand mid, len, left, etc...., the problem is that if my link file it works on the result of 100 not the formula.

solution must be an excel formula not vba please