=LEFT(<cn>,LEN(<cn>)-LEN(<hostname>)-1)
Example
=LEFT(D2,LEN(D2)-LEN(A2)-1)
Jay Everson has over 20 years experience supporting production infrastructure and software R&D Labs. He has 12+ years experience in management and has also spent time in Software Engineer, Infrastructure Architect and Team Lead roles.