Dear Excel Expert
I have found that these number formats have some issues. As values come back as #VALUE! even they are numeric. Would you be able to help me?
Also I would like to add UK for alphanumeric code as shown in D9 column. Is there any way to assist to provide a formual that if it is alpha numeric value, it will be UK&desired cell.
Thank you very much for continous help.
Regards
Shams
Hi,
Interesting. I ran a quick test and the ASCII code for the character at the end of the strings in A2 and B2 which is causing you problems (and which you can't "see") is 8203 (!).
Neither TRIM() nor CLEAN() will remove this character. If you have many like this, it may be best to look for a VBA code to clean up your data. If it's just a few, then this formula will remove that unwanted character:
=0+LEFT(A2,LEN(A2)-1)
Regards
you only need
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Using code to create UDF (user defined function)
=IFERROR(udfvalue(A2)-udfvalue(B2),"UK")
Or you could adapt the code to replace values.Please Login or Register to view this content.
Formula solution:
Please Login or Register to view this content.
Quang PT
Dear all
I really really appreciate all of your time and effort in this regards. I can express how helpful all of you are.
God will bless you.
Regards
Shams
Hi Joseph
Thank you very much. However it became very complicated for me to understand.
Regards
Shams
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks