convert excel formula into macro

Hello Everyone.

I want to convert three excel formula into macro.

1)First function, SUBSTITUTE should work on columns (H, I and J) of sheet "DATA" to remove single and multiple spaces. (e.g same formula should used like for col B of output sheet)

2)Second, user-defined function (PARSE) should work on column I and J of sheet "Data" (e.g same formula should used like for col C of output sheet)

3)Third, SUBSTITUTE should work on columns (H, I and J) of sheet "DATA" to replace semicolon with new line (e.g same formula should used like for col D of output sheet)

4)Use wrap text button so that data will be present properly.


For the demo, I put all this three formula in column B, C, D of sheet "Output" by taking a single column from old sheet.

Advance thanks for your help