1 Attachment(s)
Solved: Remove certain charachters from a cell
Hi,
I have a worksheet column in which few of the cells have some unwanted characters and I wanted to remove those unwanted characters from these cells like
PK_TTA121 in this remove "PK_" and change this to TTA121
PK_TLU955CV in this remove "PK_" & "CV" and change this to TLU955
PK_LSB6882C in this remove "PK_" & "C" and change this to LSB6882
TTB966 no change
TLS5263C in this remove "C" and change this to TLS5263
Would be grateful if somebody help me in writhing the code to do this automatically. I am also attaching the example sheet
Regards