I need help changing a cell formula to use in a macro.

In the column this formula is referencing it will have information like the following:

01575 Product 1

25427 Areas1/Areas2

89854787 Section 4

The formula is what I am using to check if the line has a space for character 6. If it does it will remove the first 6 characters. If the 6th character is not a space then it will remove the first 9 character. At the end of both it will add a "; "This will make the info look like

Product 1;

Areas1/Areas2;

Section 4;

Here is my formula

=IF(MID(

In the column this formula is referencing it will have information like the following:

01575 Product 1

25427 Areas1/Areas2

89854787 Section 4

The formula is what I am using to check if the line has a space for character 6. If it does it will remove the first 6 characters. If the 6th character is not a space then it will remove the first 9 character. At the end of both it will add a "; "This will make the info look like

Product 1;

Areas1/Areas2;

Section 4;

Here is my formula

=IF(MID(

A2;6;1)=" ";RIGHT(A2;LEN(A2)-6)&"; ";RIGHT(A2;LEN(A2)-9)&"; ")

Thank-you in advance for any help.

Thank-you in advance for any help.