ALL MISC
Friday, May 6, 2011
How to delete last 4 characters of a cell in excel
Cell
A S Rao Nagar (11)
Formula
=LEFT(B4,LEN(B4)-4)
Returns
A S Rao Nagar
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment