Separate And Delete Date Into New Cells

I have a table that I've imported into excel. Below are 2 samples of the information in the cells..

A1 = T(APPLICANT_1_RECENT_PROPERTY_TYPE_DESCRIPTION)/V(Unspecified)
A2 = T(APPLICANT_1_RECENT_PROPERTY_TITLE)/V(U)

Basically I would like to separate into 3 columns as such

From A1;
B1 = APPLICANT_1_
C1 = RECENT_PROPERTY_TYPE_DESCRIPTION
D1 = Unspecified
From A2;
B2 = APPLICANT_1_
C2 = RECENT_PROPERTY_TITLE
D2 = U

When Importing I can't use delimited or fixed width. I can do this with Find and Replace and copying cells, but thought there might be a more savvy way to do this.