![]() Because of that, two of them giving the results as “N/A”. I added the space for “Rachel Green” in the first table and “Virat Singh” in the second table. We will add one more space in between the names then we will see whether Vlookup will give results. ![]() If we observe, there is space between every word, and I have also given the length for those two names. If space is there in the beginning and space is thereafter now, we will see if the space is available in between two words. ![]() I hope you understand how the spaces will affect the formula and how to find whether spaces are there or not. In the first table, we have given space after the name hence length is 7 for the same names, and in the second table, it is 6. ![]() I have applied the LEN formula for the same names in both the tables, but the length is different in both the tables. To know the number of spaces available, we can use the formula length and can find. We will keep the space after the names “Kiran” and “Rajesh” why I am mentioning the names because we cannot identify if space is available after the name. Now we will check if space after the name will cause any problem while applying formulas.
0 Comments
Leave a Reply. |