Results 1 to 2 of 2

Thread: Removing chracters from cell

  1. #1

    Removing chracters from cell

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm wanting to know how I can remove the last 2 characters from a cell but leave the rest of the info in a cell as a number. I have used the remove function and get text left. Eg 1234568t - I want to remove 8t but leave the rest. The formula i'm using is =left(cell number,8). Any ideas?

  2. #2
    Neophyte Teethless mama's Avatar
    Join Date
    Feb 2013
    Excel Version
    Excel 2007
    mama knows best

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts