Excel Question

  steviegee 15:42 09 Jul 2007
Locked

You there again VoG!! With ref to this click here I now need to take everything away after the A and D i.e A_001 the _001

  VoG II 15:51 09 Jul 2007

Like ths?

=LEFT(C1,4)&"__"&MID(C1,5,2)

  steviegee 16:01 09 Jul 2007

That doesn't seem to work. I have AR156_16A_001 and need it to read AR156_16A so I need to lose the last 4 digits.

  VoG II 16:05 09 Jul 2007

=LEFT(C1,LEN(C1)-4)

  steviegee 16:07 09 Jul 2007

Thanks what would we do without you!!

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

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

Comment créer, modifier et réinitialiser un compte Apple ?