MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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