splitting a cell into 2
Hello,
I can't figure this one out. Via a web query, I get a
value for H2 of "1,926.09 - 1,954.62".
I'd like to, through VBA, split the value in H2 and
paste them into 2 cells, I2 and J2. The f'inal result
would be I2 = "1,926.09" and J2 = "1,954.62".
Can anyone help me?
Thanks in advance
|