Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Remove words
For possibly better answers, post some sample data and the expected results
to illustrate your description. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert numeric to words Example 525 in words (Twenty five | Excel Discussion (Misc queries) | |||
How do I remove the words Page 1 from the body of a worksheet | Excel Worksheet Functions | |||
how do i remove viewing the words Page 1 in the background in an . | Excel Discussion (Misc queries) | |||
Remove spaces between words | Excel Discussion (Misc queries) | |||
how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) |