Sunday, August 7, 2011

Leaving the last n letter from right and getting the rest - Length, Right and left Function of Excel


Length, Right and left Function of Excel


PINKYs CLINICAL LAB.xls                           PINKYs CLINICAL LAB


=LEFT(B5,LEN(B5)-4)

Note: for vice versa it can b done via conveting text to columns


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)