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
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 28, 2021
-
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
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 28, 2021
457
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!