VBA: Put extra space before units (keywords) if space is not there

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"

Please Login or Register  to view this content.