Forum Discussion

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Nov 11, 2022

    ajmal_pottekattil_yoousuf 

    That's because you have a space at the end in "HAVELOCK ONE INTERIORS LLC " in B4, whereas the first part of C4 in sheet2 has a comma directly after "LLC". Remove the space in B4 or add one before the comma in C4.

    • ajmal_pottekattil_yoousuf's avatar
      ajmal_pottekattil_yoousuf
      Iron Contributor
      Nov 12, 2022
      In this sheet more than 2000 customers are present.
      Is any equation is remove the blank space automatically.
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Nov 12, 2022

        ajmal_pottekattil_yoousuf 

        TRIM will remove leading and trailing spaces, but also multiple spaces within a text string.

        CLEAN will remove all non-printable characters from a text string.

         

        You could use them both in one go if you want. Something like:

        =CLEAN(TRIM(A1))

Resources