+ Reply to Thread
Results 1 to 3 of 3

Need help getting the last value in each row when row length varies

  1. #1
    Registered User
    Join Date
    04-20-2014
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need help getting the last value in each row when row length varies

    Hi,

    In row B of my worksheet, I have pasted the complete path and file names of my music files. Starting in row C, I have converted text to columns using "" as the delimiter.

    The final row displays the actual name of the .mp3 file, but the filenames are not all in the same column because the path length varies.

    I'm trying to pull the last value in each row, which will contain "???.mp3" into a single column, but unable to figure out how to do it.

    Please let me know if you can help.

    Thank you,
    -Scott

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,466

    Re: Need help getting the last value in each row when row length varies

    A belated welcome to the forum.

    Please confirm the version of Excel that you are currently using.


    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,466

    Re: Need help getting the last value in each row when row length varies

    Possibly this in cell A2 copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Referencing an above subtotal that varies in length
    By Bordwell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2020, 11:07 AM
  2. Replies: 7
    Last Post: 01-15-2016, 08:13 PM
  3. Moving data with varies in length
    By juegen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2015, 06:33 PM
  4. Extracting a number from a string that varies in length...
    By lucraft in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2012, 11:30 AM
  5. Find character when the length varies
    By Rookie_User in forum Excel General
    Replies: 3
    Last Post: 04-12-2006, 02:20 PM
  6. [SOLVED] number to time format when digit length varies
    By UM Win in forum Excel General
    Replies: 5
    Last Post: 12-08-2005, 10:00 PM
  7. [SOLVED] number to time format when digit length varies
    By UM Win in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2005, 10:00 PM

Tags for this Thread

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