1. Search unit keyword "kg/unit1" "kg/unit2" "kg/unit3" "kg/unit4".

VBA: Put extra space before units (keywords) if space is not there(for example: 1000kg/unit4 should be 1000 kg/unit4. If there is a space keep it as it is.)

No extra spaces should appear in all sheets except sheet A.

2. vba: Put a space between all numbers if no space appear. For example if "if My age is18 Year" should result "if My age is 18 Year"