Hello,

I am trying to remove words/letter and such to the left of a colon in multiple cells. Each cell has different things in it and i need to shorten them. below is an example of what i'm referring to. NOw not only do i need to know the formula but i need to know how to do it, step by step. I know tedious, but i need this.

eWFusePCNEW : eWFusePCNEW-NB-3000
eWFusePCNEW : eWFusePCNEW-NB-3500
eWFusePCNEW : eWFusePCNEW-NB-3500
eWFusePCNEW : eWFusePCNEW-NB-4000


Any help would be great.

Thanks.