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!
Bookmarks