if condition is met, cut off first 4 characters

[billyheanue]

Hi all,

Looking to transform

KMGW-S8004-5384

<tbody>
</tbody>

BRAU-R8205

<tbody>
</tbody>

8888301523

<tbody>
</tbody>

KEND-7176 into.. S8004-5384 R8205 8888301523 7176

<tbody>
</tbody>

Is there an excel formula that can handle all of this in one fell swoop?

Thanks!
Bill

 

[dave3009]

Probably the use of MID but you haven't told us the conditions that have to be met and your result implies that you need to cut off up to five characters.

 

[billyheanue]

Thanks Dave - I figured out a way to do it using the LEN function in cell K24

" =IF(MID(J24,5,1)="-",RIGHT(J24,K24-5),J24) "

Hopefully this works for all of the cases

 

[dave3009]

Good stuff Bill. Will keep an eye out in case you it doesn't quite work out