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.

Resources