I have a spreadsheet containing thousands of rows, each row shows a file path in the format /Root Folder Name/Nested Folder Name/File Name, however both the root folders and nested folders contain different numbers of charchters throughout. The one common element is that the nested folder always starts with a number, so for example:

/Jo Blogs and Sons/4. Annual Accounts/Fiscal Summary.xls

What I want to be able to do is to write a formula to remove the root folder name and just leave the nested folder and the file name, so I want to end up with

4. Annual Accounts/Fiscal Summary.xls

I therefore need a way of counting the number of characters before the number in each row, so I can then add this to a MID function, but I've no idea how to do this?

Can anyone suggest an easy way?

Many thanks