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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is there a way to delete all characters to the right of a ":"? 3
change "Expositor, The" to "The Expositor" 5
how do I move between sheets in a workbook using the keyboard.... 2
is there a quick way to do this besides cut and paste? 3
fill series by weekdays in XL 2007 1
Delete last number from data 1
Google Pixel 2 and Pixel 2 XL 2
fill series, custom format question 2

Back
Top