Forum Discussion

Maha82's avatar
Maha82
Copper Contributor
Mar 22, 2022

inconsistent data in Excel

How to detect there is a dot at the end of a sentence stand-alone or before HTML code.   Example:    <p>mmmmmmg mer inspirerad är Moves ett märke som du bara måste kolla in. Här på Zalando kan du...
Formulas and Functions
bosinander's avatar
bosinander
Steel Contributor
Mar 22, 2022

Hi Maha82 

If you want to spot the not wanted line break before the last end paragraph-tag this is a way.

It also finds characters outside HTML.

Attached is a way to search the expected pattern and see if it is at the expected position.

Patterns on row 1.

B2 where B1 should be found first

=IFERROR(SEARCH(B$1;$A2:$A7)=1;FALSE)

C2 where C1 should be the last string

=IFERROR(SEARCH(C$1;$A2:$A7)=LEN($A2:$A7)-LEN(C$1)+1;FALSE)

 

  • Maha82's avatar
    Maha82
    Copper Contributor
    Mar 23, 2022
    Thank you so much for the help. I have sent you a private message in this regard. I will appreciate if you can still assist.
  • Maha82's avatar
    Maha82
    Copper Contributor
    Mar 22, 2022
    Thank you so much, I tried to apply it in a wide range but failed to do it. I will try again and let you know if I still have any questions