Excel Question

  steviegee 15:42 09 Jul 07
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 07

Like ths?

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

  steviegee 16:01 09 Jul 07

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 07

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

  steviegee 16:07 09 Jul 07

Thanks what would we do without you!!

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

Surface Pro (2017) vs Surface Pro 4

Where HTML5 is headed next

MacBook Pro v Surface Pro 5