Help With Formula/Macro

  steviegee 14:16 23 Mar 2009

I have the following data in cell I2

1.8 04/99-10/08 or 2.0D 02/00-04/06 (data varies)

What I need is to copy the 1.8 or 2.0D into M2, the 04/99 or 02/00 into D2 and the 10/08 or 04/06 into E2.

I dont know whether I need a formula or a macro but the data varies down about 5000 rows.

Thanks for any help you can give me.

  VoG II 14:33 23 Mar 2009

For the first bit

=LEFT(I2,FIND(" ",I2)-1)

for the second

=MID(I2,FIND(" ",I2)+1,5)

and the third


  steviegee 10:04 24 Mar 2009

Thanks VoG

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires