Thursday, March 25, 2010

Excel Strip the first characters from a cell

I always forget this:

=RIGHT(A1,LEN(A1)-2)

In the above example 2 is the number of cells to strip off.
Posted by at 4:35 AM
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)