Hi,
That didnt didnt work, i think this part is wrong "IF(ISNUMBER(SEARCH("SR ",C62)),C62,"

Rather than return what is in the cell can we get it to skip to the next instance of a "*"

Does that makes sense?

e.g.
This data (3 rows):
223596 Facilities Management
* SR Contracted Out Services
** Production Other Overhead


Would need to be written as
223596 Facilities Management** Production Other Overhead

Rather than

223596 Facilities Management* SR Contracted Out Services

For reference the "*" indicate a subtotal - they are all correct apart from the "SR Contracted out" and "SR Maintenance accounts only" - these two I need to ignore/skip