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!

    Hi
    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
    =left(a1,len(a1)-2)
    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
  •