delete/extract various text strings from cells

hi!

i am cleaning up years of contacts from my google account... [i wish there was a manual somewhere with step by step guidance and some vba to assist in this]
this might be the 1st of a couple of requests for help.

the problem:
there are cells with text strings like "watsonphone" or "smithfamily" or "039155672given" - i want to clean the data by deleting, in this case, the "phone", "family" or "given" - there are other strings.

i am not a programmer and only venture into excel infrequently, so please spare me the flames

let me know if this requires 'commercial services'

it's been a couple of days but have a wonderful rest of 2021!

God bless
gabriel

Assuming;
Data is in Col.A and output in Col.B
Such word is always at the end.

Please Login or Register  to view this content.

tx jindon, i believe my request was to vague... let me try again.
1st off your code did exactly what it said, but your solution and my problem don't see eye to eye.
my text strings occur randomly over many columns/rows and are not always the same length and could be in front. middle or back of the text i would like to keep.
also the text i want to keep must stay in the same cell, thus if c24 is say "myunclebob" and i want to get rid of "myuncle" i should somewhere in the code be able to enter "myuncle" [or whatever], run the code and be left with bob in cell c24 - "myuncle" must be gone
in other words i will have to be able to adjust whatever i want to be deleted within the code, preferably more than one text string at a time in order to save time, for instance i will have to instruct the vba to delete "family", "given", "phone", "whatever" etc on the sheet in all of the cells.

Can't you just have a separate sheet with all the strings to be deleted... then code can delete all at once...

hi folks, thanks for joining from the mothercity sintek, the solution just popped into my brain... no xtra code needed, just untick "match entire cell contents" see image. and voila!... or in southafrican 'lekker my bra' , so prob SOLVED! enjoy your day!
Attachment 711654
God bless
gabriel

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Originally Posted by AliGW

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

just did tx aligw!