HI all,
I have a file where there are products with variations in their name I have to create a Parent for each group, how ever the parent should not have the variation info in the titleso i have to manually delete it after i create the parents.
Im looking for a function that will compare 2 cells, (the first cell and the cell below it) and compare the differences between the 2 and return only the common part.
ex:
Curvaceous Womens Plus Size Black Crop Lace Trimmed Leggings - 18
Curvaceous Womens Plus Size Black Crop Lace Trimmed Leggings - 20
output:
Curvaceous Womens Plus Size Black Crop Lace Trimmed Leggings -
example:
Nike T-shirt Red & Blue Large For Men
Nike T-shirt Green Small For Men
output:
Nike T-shirt For Men
really need some help with this( Will give recognition and everything)
Thanks!!
Bookmarks