I have a list of 1000s of different labels and need to remove the space between the number and mg. Sometimes the space is present and other times it's not. The position of the text "mg" is not the same in every cell (there might be four words before it or only one) so I assume vba code would be the easiest option.
An example of part of the list:
IBUPROFEN 5 MG TAB
IBUPROFEN 5MG TAB
IBUPROFEN 5 MG TAB
IBUPROFEN 5MG TAB
ESTRADIOL 0.5 MG TAB
ESTRADIOL 0.5 MG TAB
ESTRADIOL 0.5MG TAB
ESTRADIOL 0.5MG TAB
ESTRADIOL 0.5MG TAB
ATORVASTATIN TAB 20MG
ATORVASTATIN TAB 20 MG
ATORVASTATIN TAB 20 MG
ATORVASTATIN TAB 20 MG