Forum Discussion
Sandra_V670
Apr 18, 2023Copper Contributor
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
- NikolinoDEPlatinum Contributor
Please include the following info to help others answer your question:
- Sandra_V670Copper 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.