LinkBack URL
About LinkBacks
How do you remove the last 2 digit
ie.
A B
12345688 88
12548963 63
14552365 65
So in column B is would show
88
63
65
How do you remove the last 2 digit
ie.
A B
12345688 88
12548963 63
14552365 65
So in column B is would show
88
63
65
Last edited by TaGY2K; 06-03-2009 at 10:54 AM.
=right(a1;2)
Never use Merged Cells in Excel
If you want to perform calculations on your results (e.g. SUM), then you'll need to modify the formula to
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Perhaps =MOD(A1,100)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks