Help deleting duplicate text in a cell

[cbreneman]

I have a sheet with 3 columns of data. Fund Family, Fund Name, Share class. The Fund Name column includes the Fund Family and the Share class information. I would like to know how I can automate the deletion of that information from the Fund Name column.
Example

Existing =

Family	Name	Class
ABC	ABC Growth A	A
Alger	Alger Small Cap Inst	Inst

Would like to end with

Family	Name	Class
ABC	Growth	A
Alger	Small Cap	Inst

Thank you.

Corey

[hulpeloos]

I don't know how much you know about VBA but you will want to work with creating a new string for the second column by using Replace(Name, Family, "")

Replace xyz with your sheet name and make sure to reference the correct columns

Please Login or Register  to view this content.

[cbreneman]

Thank you hulpeloos. I have one question. The end result for the changed column is leaving a space at the beginning and at the end. It is deleting the desired text, but leaving a blank space as a bookend. How would the code be changed to eliminate those unwanted spaces. Again, thank you for your previous response!
Example...where _ = space...

ABC	_Growth_	A
ABC	Growth	A

[cbreneman]

I figured it out! Thank you so much for your assitance. It was greatly appreciated!!!