Hot to split data?

[ebiscaro]

Hi,


In two different table, I got the TEXT data below to compare.
What I would like to do is split the text in 3 columns so I can then subtract the numerical value.


Is that feasable?

S6 32 41.996 S6 32 41.9962
S7 53 15.903 S7 53 15.9039
S7 54 09.694 S7 54 9.6948
S7 54 17.781 S7 54 17.7814
S6 33 26.453 S6 33 26.4533

Thank you

 

[RuralGuy]

Look up Split() in VBA help.

 

[Epic]

use combination of mid(),left(),Right() to detach and instr() to find [Space] character and val() to convert the results into a number.

 

[ebiscaro]

cheers to all

That worked!