+ Reply to Thread
Results 1 to 5 of 5

Excel Formula to extra partial data based on a Delimiter

  1. 02-22-2024, 03:07 PM #1
    k2nike
    k2nike is offline
    Registered User
    Join Date
    07-04-2020
    Location
    Dubai
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2404 Build 16.0.17531.20190) 64-bit
    Posts
    39

    Excel Formula to extra partial data based on a Delimiter

    Hi,

    I am trying to create Folder names for different project folders based using "&" function.

    However one of the data in a cell has a "/" symbol included so when I copy the folder name the / symbol cannot be copied.

    Below for example-

    Invoice No. - FZE 8011
    Reference Number - FPO-2256/2023
    Client - Mechatronics Industrial Equipment L.L.C

    Using a Formula The result I get is FZE 8011 - FPO-2256/2023 - Mechatronics Industrial Equipment L.L.C

    The result I want is FZE 8011 - FPO-2256 - Mechatronics Industrial Equipment L.L.C.

    So basically in the Reference number cell whatever comes after "/" should be removed. Please advise how I can extract or select only partial data from reference cell. Attached sheet for reference. AUMA reference cell I want to extract only the text before "/".
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-22-2024, 03:13 PM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.90.2 (24102719))
    Posts
    8,969

    Re: Excel Formula to extra partial data based on a Delimiter

    are still using 2010 version

    if 365 / later version text before
    =A2 & " - " &TEXTBEFORE(D2,"/")& " - " &F2
    will they always have a /
    if not
    =A2 & " - " &IFERROR(TEXTBEFORE(D2,"/"),D2)& " - " &F2

    Otherwise
    =A2 & " - " &LEFT(D2,SEARCH("/",(D2))-1)& " - " &F2

    will they always have a /
    otherwise the above will give an error
    =A2 & " - " &IFERROR(LEFT(D2,SEARCH("/",(D2))-1),D2)& " - " &F2
    Attached Files Attached Files
    Last edited by etaf; 02-22-2024 at 03:20 PM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 02-23-2024, 02:44 AM #3
    k2nike
    k2nike is offline
    Registered User
    Join Date
    07-04-2020
    Location
    Dubai
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2404 Build 16.0.17531.20190) 64-bit
    Posts
    39

    Re: Excel Formula to extra partial data based on a Delimiter

    Thank you!
    Reply With QuoteRegister To Reply
  4. 02-23-2024, 03:31 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    88,918

    Re: Excel Formula to extra partial data based on a Delimiter

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, remember that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 02-23-2024, 04:50 AM #5
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.90.2 (24102719))
    Posts
    8,969

    Re: Excel Formula to extra partial data based on a Delimiter

    you are welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [SOLVED] Rearranging Data Based on Delimiter
    By chullan88 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-25-2024, 07:23 AM
  2. [SOLVED] Creating a list according to partial duplicates & Incrementing delimiter in TEXTJOIN
    By gotmort in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2022, 05:00 AM
  3. [SOLVED] Formula to split text based on a specific delimiter
    By Roibeard in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-09-2020, 09:00 AM
  4. [SOLVED] Take cell value spit on delimiter SORT the ensuing array then Join on delimiter post back
    By capson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2016, 03:54 PM
  5. organizing data in excel when there is no header nor delimiter
    By sabrensa in forum Excel General
    Replies: 10
    Last Post: 01-12-2015, 01:19 AM
  6. [SOLVED] Splitting data based on delimiter
    By sathishkm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2014, 05:59 PM
  7. extra hours adding money for each extra hour worked FORMULA
    By cynthiamcastro in forum Excel General
    Replies: 3
    Last Post: 06-18-2012, 11:27 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1