string manipulating function?

I'm looking for a way to split a field into 2 values, my field always
contains the 2 varaibles FullName - Office, I want to split it to FullName
and to Office into 2 disctintive fields.

For example: John Doe - HisOffice
should become:

Jon Doe
Office

Any help is appreciated.
.