Excel macro for data conversion

Need a macro that breaks out a text data field into 3 other fields. The first 50 rows of the attached file show samples of the data that has been broken out. The macro should convert the remaining rows of the file by executing the macro one time. The delivery would include the converted data and the macro so it can be run on different data files with the same structure. Note that any time the source data contains the word "(loss)", the percentage should be changed to a negative number. There may be a few rows with anomalous data that will not convert. It is ok if the macro doesn't convert these, as long as the macro runs through all of the data.