Forum Discussion
LEFT FUNCTION RESULT CANT READ BY MATCH
Hi, Would like to ask some assistance from here. I first did a formula for LEFT function and I got the correct value. But when i used that cell in my match function, it appears error. I manually typ...
This is the sample code i need to match. 11005-Q-PC
First thing I did is to do a column for LEN function and I got a result of 10.
After LEN, I create a function of LEFT and I need to remove the -q-pc and I create a fomula like this. =LEFT(A2,N2-5)
=LEFT(11105-Q-PC,10-5)
result is 11005 ( the code is correct)
Note all data are in general
After this, I need to match now and use the result of LEFT but it errors
Try this:
=--LEFT(A2,N2-5)
The -- convert the result of LEFT (which is text) to a number.