Customer Contact List Report to list Jobs Info but only the upper level Customer name (no :JobName added)

Unfortunately there isn't a way to change how the name field on reports looks within QuickBooks.  About the only think you can do is send the report to Excel and delete the unwanted information or write a formula in another column to only show the Job.

For example, this formula will work to remove the customer name:

=MID(A2,FIND(":",A2)+1,LEN(A2))

Thank you. I could do that since I am actually exporting the reports data into excel anyway. However, I need Customer name and not the job name, in other words everything before the ":". How can I extract that first part?

Thank you. Really appreciate your help.