Formula for adding space between last number and first letter in cell

[DanEveritt]

Hi all

I have the following formula for adding a space between the last number and first letter in a given cell:

=TRIM(REPLACE(H2,MIN(FIND({1,2,3,4,5,6,7,8,9,0},H2&"1234567890")),0," "))

I am trying to use it to add a space in a list of measurements:

25g
100g
1g
250mg
100mg
10g
1g
10ug

I am struggling to get the formula to work properly. At the moment, it is outputting the same as the source cell.

Can anyone advise on where I've gone wrong?

Thanks so much!

[Pepe Le Mokko]

You need to use

Please Login or Register  to view this content.

Entered as an array formula with Ctrl+Shift+Enter
Your formula works when text precedes numbres

[DanEveritt]

Fantastic, thank you! Works like a charm

[Pepe Le Mokko]

You're welcome