Previous Topic Next Topic

Help: Need formula to find missing text comparing 2 cells

Solved/Closed
alexm88 Posts 1 Registration date Tuesday March 31, 2020 Status Member Last seen March 31, 2020 - Mar 31, 2020 at 10:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 14, 2020 at 11:53 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Updated on Jul 23, 2020 at 11:31 AM
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