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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…