Deleting last 4 characters in a range
Posted by Rick on March 23, 2001 11:18 AM
How can I delete the last 4 characters in a range.
Example:
I have
K23T12/KK/SS/OCE
K887T8/WW/SS/LK/OCE
I want:
K23T12/KK/SS
K887T8/WW/SS/LK
THANKS
Posted by mseyf on March 23, 2001 11:29 AM
if data starts in A1,
=LEFT(A1,(LEN(A1)-4))
and copy down
Mark
