Forum Discussion
Used xlookup and came back with result #n/a although text fields are the same
Thanks, Riny. I think this is exactly what I was looking for. By the way, once I paste the text, how do I find out which character to fix? Is there any reference for code? I am sorry I am new to this and need your further help please. Thanks, appreciated.
TANACAL125 Sorry, I wasn't clear. Copy columns B, C and D and paste them somewhere towards the right. Then enter your other text (the one that looks the same but doesn't match). Now compare the two code columns to see what the character codes don't match.
Riny_van_Eekelen Thanks so much for your explanation. Appreciated.
May I ask you for one more help? Can you help me to understand the formulas?
=MID(B2,SEQUENCE(LEN(B2)),1)
=CODE(C2#) [can you help me with # in the formula as well? 🙂 ]
Much appreciated.
The MID and SEQUENCE functions split the text into its individual characters. The # sign tells Excel to take the entire spilled result of what is in C2. In traditional you would just say =C2 and copy it down.
Look in the attached link to learn more about these Dynamic Array functions.
Riny_van_Eekelen Wow, that is AMAZING! I read the link you provided and I searched for more youtube videos to digest more in depth on the these new formulas as well.
Thanks so much for your sharing. You brighten my weekend with this new knowledge. I really appreciated it all.
And thanks for your coaching. Hopefully, I have more chances to learn more from you. Do I need to mark this post as "completed"? If yes, do you know how? I have tried to look for options but was not successful. Please let me know so I can recognize your effort/help. Thanks,