Forum Discussion

Sandra_V670's avatar
Sandra_V670
Copper Contributor
Apr 18, 2023

Re: LEFT FUNCTION RESULT CANT READ BY MATCH

Does it need to be all in general? the code contains Letters and numbers and set as General.

2 Replies

    • Sandra_V670's avatar
      Sandra_V670
      Copper Contributor

      Thank you NikolinoDE . The look up value contains numbers and letters but when I apply the LEFT Formula, numbers will only be left as data.  The data format is in general.  I got the right value Im looking for after LEFT but when I do match function and uses the DATA reslt in my LEFT function, it appears error.

Resources