Sarfaraz
01-04-2017, 09:53 PM
Hi,
I have a big spread sheet with multiple values, I like to write a code which find the value starting with PK and four numbers and remove these. like
Actual Value in the cell Desired Value in same cell after running the macro
PK0100 KARACHI KARACHI
PK0120 LAHORE LAHORE
PK2120 ISLAMABAD ISLAMABAD
I would be grateful if somebody help me writing this code
I have a big spread sheet with multiple values, I like to write a code which find the value starting with PK and four numbers and remove these. like
Actual Value in the cell Desired Value in same cell after running the macro
PK0100 KARACHI KARACHI
PK0120 LAHORE LAHORE
PK2120 ISLAMABAD ISLAMABAD
I would be grateful if somebody help me writing this code