Hi All,
I'm looking to remove the duplicate text in a column of cells the are not separated by delimiters. For example, a cell will contain the text "FashionFashion", while another cell will contain "Home & GardenHome & Garden". My goal is to separate these cells to only contain "Fashion" and "Home & Garden", respectively. I've attached a screenshot of the actual data I'm working with for reference.
I've been looking for any formula or VBA solutions, but have come up short. Any help/suggestions would be much appreciated.
Best,
Ryan
I'm looking to remove the duplicate text in a column of cells the are not separated by delimiters. For example, a cell will contain the text "FashionFashion", while another cell will contain "Home & GardenHome & Garden". My goal is to separate these cells to only contain "Fashion" and "Home & Garden", respectively. I've attached a screenshot of the actual data I'm working with for reference.
I've been looking for any formula or VBA solutions, but have come up short. Any help/suggestions would be much appreciated.
Best,
Ryan