Results 1 to 3 of 3

IDs separation in different column ending with "/"

Threaded View

  1. 06-02-2022, 10:13 AM #1
    vijayca
    vijayca is offline
    Registered User
    Join Date
    11-24-2013
    Location
    Mumbai
    MS-Off Ver
    Office 365
    Posts
    85

    IDs separation in different column ending with "/"

    Dear Experts,

    Is it possible to separate below IDs in P column ending with "/" or "," in individual column say Q,R,S,T,U,V either through excel formula or VBA code ? There are several entries in column P.

    Column P
    Row 1 000396732514/0004127444/0004127488/0004127499/0004127501/0004127515
    Row 2 000396732514/0004127444/0004127488/

    Result
    Column Q Column R Column S Column T Column U Column V
    Row 1 000396732514 0004127444 0004127488 0004127499 0004127501 0004127515
    Row 2 000396732514 0004127444 0004127488

    Thanks in advance.
    Regards
    Last edited by vijayca; 06-02-2022 at 10:17 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to Substitute "11" with "11th" without ending up with "11th11th"?
    By bcianni in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-21-2019, 03:20 PM
  2. [SOLVED] Please help, "C2" cell should show if ending three digits with ie "1.90 and 1.85 only"
    By feroz763 in forum Excel General
    Replies: 6
    Last Post: 12-07-2017, 06:46 PM
  3. [SOLVED] Experts please help, "C2" cell should show if ending three digits with ie "9.95"
    By feroz763 in forum Excel General
    Replies: 6
    Last Post: 12-05-2017, 05:21 PM
  4. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  5. [SOLVED] Replace all values with "0" ending to the value with "5" ending
    By mgecelov in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-04-2017, 02:39 PM
  6. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  7. Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"
    By virsilens in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-06-2013, 12:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1