New_Here
04-20-2017, 06:43 PM
Hi Good Morning from Sri Lanka,
I have sets of words in cell A1,A2,A3 in Sheet 1
I have a Range which I look to remove from above Cells (plus I will continue to update that Colomn), They are in Sheet 2, Colomn 4 (ex for words are - Trusted User, Call Now, Sale)
Now I need the following to happen:
A1 = ABC Company Trusted User
Result in B1 = ABC Company
A2 = ABC Company Sale
Result in B2 = ABC Company
A3 = JnH Users and Distributors Call Now
Result in B3 = JnH Users and Distributors
Is this possible?
I have sets of words in cell A1,A2,A3 in Sheet 1
I have a Range which I look to remove from above Cells (plus I will continue to update that Colomn), They are in Sheet 2, Colomn 4 (ex for words are - Trusted User, Call Now, Sale)
Now I need the following to happen:
A1 = ABC Company Trusted User
Result in B1 = ABC Company
A2 = ABC Company Sale
Result in B2 = ABC Company
A3 = JnH Users and Distributors Call Now
Result in B3 = JnH Users and Distributors
Is this possible?