+ Reply to Thread
Results 1 to 5 of 5

Removing the last characters on a cell

  1. #1
    Registered User
    Join Date
    09-27-2018
    Location
    london
    MS-Off Ver
    excel
    Posts
    69

    Removing the last characters on a cell

    Hi,

    I hope you can help

    From cells below I need to remove the last characters as soon as first "-" is found, starting from right

    SINV/0086572-87
    2307-860098-01
    2307-859937-09

    I hope this makes sense

    Thanks

    Vito

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Removing the last characters on a cell

    Import your table to Power Query. Split the column of data using the delimeter "-" with one occurance from the right. Delete the split column. Close and Load.

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    09-27-2018
    Location
    london
    MS-Off Ver
    excel
    Posts
    69

    Re: Removing the last characters on a cell

    Hi Alan,

    Thanks for the message

    Is there a formula I can use to achieve this?

    Vito

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,892

    Re: Removing the last characters on a cell

    Try this

    =LEFT(A1,-LOOKUP(0,-(SEARCH("-",A1,ROW(INDIRECT("1:"&LEN(A1))))))-1)

  5. #5
    Registered User
    Join Date
    09-27-2018
    Location
    london
    MS-Off Ver
    excel
    Posts
    69

    Re: Removing the last characters on a cell

    Thank you, it works

    Cheers

    Vito

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Removing Certain characters from a cell value
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-29-2016, 02:53 PM
  2. [SOLVED] Removing characters from a cell
    By SHUTTEHFACE in forum Excel General
    Replies: 5
    Last Post: 06-14-2016, 10:24 PM
  3. [SOLVED] removing characters from a cell
    By tdf2437 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-17-2014, 06:21 PM
  4. Excel 2007 : Removing characters in a cell
    By whofan in forum Excel General
    Replies: 24
    Last Post: 09-23-2011, 01:30 PM
  5. Removing characters from a cell
    By xtrout in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-12-2007, 07:19 PM
  6. Removing first 3 characters of cell
    By yewkiang in forum Excel General
    Replies: 2
    Last Post: 12-17-2006, 11:49 PM
  7. [SOLVED] removing some of the characters from a cell
    By Patience in forum Excel General
    Replies: 2
    Last Post: 05-03-2005, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1