Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: extract last word 4 multiple cells

    i need to just keep the last word of my cell for about 5000 cells.

    i.e. Clothing:LSTP1000 i only need the LSTP1000

    but i need to do this for 5000 cells, on all of them i need everything after the colon

    Thank you for your help!

  2. #2
    Join Date
    Dec 2003
    San Diego, CA
    Welcome to the Board!

    Here's a formula approach: =RIGHT(A1,LEN(A1)-FIND(":",A1))

    Or faster would be to highlight the entire range and goto Data-->Text to Columns-->Delimited. Select "Other" and enter a Colon. It will parse your information into two seperate columns.

    Hope that helps,


    EDIT: Typo

Posting Permissions

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