Dear friends in my worksheet column "F" two type of data available like below....
i want to remove some parts in that data. like below..
pls help me.how i can do that..
Code:
TEX-24-1000M PP(45/2)
TEX-105-1000M PP(12/2)
TEX-80-1000M SSP(16/2)
Code:
20/2-2000M SSP
40/2-2000M PP
60/2-2000M SSP
i want to remove some parts in that data. like below..
Code:
452PP
122PP
162
Code:
20/2
40/2
60/2PP
pls help me.how i can do that..