Results 1 to 6 of 6

Extracting data after last dot(.) or comma(,)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    Extracting data after last dot(.) or comma(,)

    Hi,
    The nature of data is similar to it at posthttps://www.excelforum.com/excel-pro...-brackets.html ,I have another things to extract that is the data after last dot(.) or comma(,) if exists,else leave intact.Workbook is enclosed for your kind reference.Here,data is the original worksheet & required is the output worksheet.However the result is required in the same worksheet and not is seperate worksheet which have already done in above link as contributed by forum contributor "Jindon"
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 10-17-2017, 07:31 AM
  2. [SOLVED] Extracting information from a comma separated list of values in one cell
    By cardiff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2012, 09:17 PM
  3. Extracting Numbers Before and After A Comma
    By treeantz in forum Excel General
    Replies: 6
    Last Post: 07-16-2012, 09:21 PM
  4. Extracting data from a cell to the right of a comma
    By kufta4 in forum Excel General
    Replies: 4
    Last Post: 12-17-2011, 07:46 PM
  5. help extracting comma separated data
    By tn80 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2008, 11:30 PM
  6. Extracting Comma Seperated data into individual Cells
    By Rmcnaught in forum Excel General
    Replies: 2
    Last Post: 07-18-2006, 04:04 PM
  7. Extracting comma seperated data to new sheet
    By Rmcnaught in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2006, 04:18 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