Torx's Mind
Random IT stuff that I have picked up here and there.
Wednesday, February 09, 2011
Excel Replace last 2 values with another
=LEFT(B2,LEN(B2)-2) & CONCATENATE("1")
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment