how to delete last X number of characters in a cell

  • Thread starter Thread starter gerry.lisa
  • Start date Start date
If you want to get rid of the rightmost 4 characters from cell A1, for
example, use this:

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

Hope this helps.

Pete
 
That did it...thanks!!

....Lisa

If you want to get rid of the rightmost 4 characters from cell A1, for
example, use this:

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

Hope this helps.

Pete



- Show quoted text -
Click to expand...
 
Back
Top