Hi all,
I would like to ask for solution as my left/right formula isn't working.
eg. I20070095 <- I need to use right formula to capture the last 3 digits. Formula: =right(cellA1,3)
Somehow the end result appear as 009 instead of 095.
I have checked, there is no hidden space anywhere. But seems like in one of the numbers, there is an additional character in it.
How do I solve such issue?
Reply With Quote