Help With Formula/Macro

  steviegee 14:16 23 Mar 09
Locked

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 09

For the first bit

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

for the second

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

and the third

=RIGHT(I2,5)

  steviegee 10:04 24 Mar 09

Thanks VoG

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac