Hi,
I have very common problem of Substitution. I have attached an excel file where column A and Column B contains text strings. Both of these text strings to be removed from the Tex present in column C. And the output should be in column D. I have tried substitute function but that is not working for unknown reason.
excel forum Snapshot.PNG
Please help me on this issue.
Thanks and regards,
First, try to use TRIM(original text) to delete extra space, then
Try using search function to test, and found out some typos in column A/B:
Column B: "Orignally" => should be "Originally"
A4: "including his childhood friend Pat Martino , " => should be "including his childhood friend Pat Martino, " (delete 1 space after "Martino"
similar checking process to A12
After fixing, try substitute:
=SUBSTITUTE(TRIM(C2),A2,"")
Attachment is my testing with SEARCH function first, to help you know how to do if SUBSTITUTE fails.
Quang PT
Hi, the formula works but it doesn't remove the Orginally posted by line as I have shown in the screenshot below. Please let me know about your thoughts.
Attachment 709352
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks