View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alldreans alldreans is offline
external usenet poster
 
Posts: 1
Default 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