How could I take data and parse it into a new table?

Suppose I have a field called CustName:

Mr B Cooney


And what to break it out into 3 different fields; we'll call them CustSal, CustFI, CustLName, respectively:

CustSal: Mr
CustFI: B
CustLName: Cooney