if condition is met, cut off first 4 characters

[billyheanue]

Hi all,

Looking to transform

[TABLE="width: 138"]
<tbody>[TR]
[TD="class: xl64, width: 138"]KMGW-S8004-5384[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 138"]
<tbody>[TR]
[TD="class: xl66, width: 138"]
BRAU-R8205[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 138"]
<tbody>[TR]
[TD="class: xl66, width: 138"]8888301523[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 138"]
<tbody>[TR]
[TD="class: xl66, width: 138"]KEND-7176

into..

S8004-5384
R8205
8888301523
7176[/TD]
[/TR]
</tbody>[/TABLE]

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