If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.Register here so that you can post in the forums or comment on the articles.
Register for a FREE account, and/ or Log in to avoid these ads!
Hi, how to remove last digit. following example given below. Before After 1234 123 456 45 78964 7896 69 6 4587 458 can anybody solve the issue ?
Use =--LEFT(A2,LEN(A2)-1)
Thanks sir.
An alternative =ROUNDDOWN(A2/10,0)
working fine. Thanks sir.
Forum Rules
Bookmarks