Remove words
We would like to have a if statement to remove the last word of column a is
the same word appears in column B. even though it does want more than one word in column a so basically the if statement is going to be if the last word of column a is the same of column B. delete only the last word in column a Thank You |
Remove words
For possibly better answers, post some sample data and the expected results
to illustrate your description. |
Remove words
Hi
Try this formula in column C: =IF(RIGHT(A1,LEN(B1))=B1,LEFT(A1,LEN(A1)-LEN(B1)),A1) Hopes it helps Regards, Per "dk" skrev i meddelelsen ... We would like to have a if statement to remove the last word of column a is the same word appears in column B. even though it does want more than one word in column a so basically the if statement is going to be if the last word of column a is the same of column B. delete only the last word in column a Thank You |
All times are GMT +1. The time now is 03:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com