Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

The MID and MIDB functions in Excel return a specific number of characters from a text string starting at the position you specify.

It is very easy to dissect the contents of a cell in Excel using the functions LEFT, MID, and RIGHT. All three functions are easy to learn.