Put space between number and alpha characters

I need help please. I have a long list of items, I need to insert a space in between numeric and alphacharacters.

For example: this is one text in a cell:

SMR (SUBMUCOUS RESECTION) SET KILLIAN NASAL SPECULUM 50MM 2 KILLIAN NASAL SPECULUM 65MM 2 KILLIAN NASAL SPECULUM 75MM 2 KILLIAN NASAL SPECULUM 90MM 2 SCALPEL HANDLE NO.3 2ADSON FRAZIER SUCTION TUBE 2.33MM 2 ADSON FRAZIER SUCTION TUBE 2.6MM 2BACKHAUS TOWEL CLIP 90MM 6RAMPLEY SPONGE HOLDING FCPS 180MM 4 ADSON FORCEPS FINE 1/2TH 127MM 2 JANSON NASAL DRESSING FORCEPS 160MM 2 CRILE ARTERY FORCEPS STR 140MM 2ROCHESTER PEAN ARTERY FCP S COF 165MM 2HALSEY NEEDLE HOLDER 125MM 2 ALLIS TISSUE FORCEPS 5/6TH 150MM 2 JANSEN MIDDLETON SEPTUM FCPS 185MM 2FREE R KNIFE FLAT ROUNDED BLADE 190MM 2BALLENGER KNIFE STR REVOLV BLADE 6X200MM 2 BALLENGER KNIFE STR REVOLV BLADE 8X200MM 2FREER DOUBLE ENDED ELEVATOR 190MM 2MCKENTY RASPATORY DOUBLE ENDED 190MM 2AURAL SNARE COMPLETE WITH WIRE 160MM 2HEYMANN TURB SCISSORS ANGULAR 180MM 2MCINDOE NASAL CHISEL 11MM X152MM 2COTTLE MALLET 190MM 2 ROUND BOWL 0, 4 LITRE 2CONTAINER BOTTOM 3/4 HEIGHT 90MM 2 CONTAINER LID 3/4 2IDENTIFICATION LABEL 2PERFORATED BASKET 3/4 56MM

What will be the desired output ?

Just what I needed! Thank you so much.

What if it's like this:

Problem:
ZINC SULPHATE 22.5MG/25MG ELEMENTAL TAB

Using AddSpace, the result is this:

ZINC SULPHATE 22 .5 MG/25 MG ELEMENTAL TAB

It would be best if the result will be:

ZINC SULPHATE 22 .5 MG/ 25 MG ELEMENTAL TAB

Also note that; in the revised function's returned value, there is no space before the decimal seperator.

Thank you so much!

Need to remove space between numbers within a long text

For example:

POUCH, STERILIZATION, 3.5X4 4IN, SELF-SEALING, BLUE, TENTED TRANSPARENT FILM, EASY DETECTION, EXTERNAL AND INTERNAL INDICATOR, MULTIPLE SEAL, 10 00POUCHES/BOX

Desired Output

POUCH, STERILIZATION, 3.5X44IN, SELF-SEALING, BLUE, TENTED TRANSPARENT FILM, EASY DETECTION, EXTERNAL AND INTERNAL INDICATOR, MULTIPLE SEAL, 1000POUCHES/BOX

thank you!

For example:

POUCH, STERILIZATION, 3.5X4 4IN, SELF-SEALING, BLUE, TENTED TRANSPARENT FILM, EASY DETECTION, EXTERNAL AND INTERNAL INDICATOR, MULTIPLE SEAL, 10 00POUCHES/BOX

Desired Output

POUCH, STERILIZATION, 3.5 X 44 IN, SELF-SEALING, BLUE, TENTED TRANSPARENT FILM, EASY DETECTION, EXTERNAL AND INTERNAL INDICATOR, MULTIPLE SEAL, 1000 POUCHES/BOX

I use the AddSpace and its working fine, please could you also remove the space between numbers inside the cell?

For example:

POUCH, STERILIZATION, 3.5X4 4IN, SELF-SEALING, BLUE, TENTED TRANSPARENT FILM, EASY DETECTION, EXTERNAL AND INTERNAL INDICATOR, MULTIPLE SEAL, 10 00POUCHES/BOX

Desired Output

POUCH, STERILIZATION, 3.5 X 44 IN, SELF-SEALING, BLUE, TENTED TRANSPARENT FILM, EASY DETECTION, EXTERNAL AND INTERNAL INDICATOR, MULTIPLE SEAL, 1000 POUCHES/BOX

You can try this;

Please Login or Register  to view this content.

Thanks a lot! It worked fine.