Help: Need formula to find missing text comparing 2 cells [Solved]

Report
Posts
1
Registration date
Tuesday March 31, 2020
Status
Member
Last seen
March 31, 2020
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
Hello guys
I have the same issue.

A2: The price includes VAT
B2: The price

In the next column, I want the following value (the text difference between A and B)
C2: includes VAT

-------------------------------------
Not working solutions:
Text to Columns is not working with words.
=IF(a2=b2,"",a2) returns "The price"

Other solutions?

1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Alex,

Assuming the 'to be extracted data' is always on the right, give the formula a try:
=TRIM(RIGHT(A2,LEN(A2)-LEN(B2)))

Best regards,
Trowa

1
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2942 users have said thank you to us this month