+ Reply to Thread
Results 1 to 5 of 5

formula required to delete specific characters from between a lin

  1. 03-02-2019, 07:46 AM #1
    sparkerk5
    sparkerk5 is offline
    Registered User
    Join Date
    03-02-2019
    Location
    india
    MS-Off Ver
    16
    Posts
    46

    Lightbulb formula required to delete specific characters from between a lin

    Dear Team,

    I am looking for a formula which will help me delete specific charachter from between a line and give the output of the remaining characters

    example

    Anaa - French Polynesia / Anaa Airport / (AAA)

    I want the middle characters to be deleted after - and before(

    The result should be like this

    Anaa (AAA)


    Please help
    Reply With QuoteRegister To Reply
  2. 03-02-2019, 08:59 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: formula required to delete specific characters from between a lin

    Hi,

    Based on the logic you give:

    =TRIM(REPLACE(A1,FIND("-",A1),MMULT(FIND({"-","("},A1),{-1;1}),""))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 03-02-2019, 09:43 AM #3
    sparkerk5
    sparkerk5 is offline
    Registered User
    Join Date
    03-02-2019
    Location
    india
    MS-Off Ver
    16
    Posts
    46

    Re: formula required to delete specific characters from between a lin

    Dear Sir,

    Thanks for the revert

    It worked like a charm

    Regards,formula.jpg
    Attached Images Attached Images
    Last edited by sparkerk5; 03-02-2019 at 09:56 AM.
    Reply With QuoteRegister To Reply
  4. 03-02-2019, 10:35 AM #4
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: formula required to delete specific characters from between a lin

    I don't understand the combination of your comment and screenshot.

    Is this resolved?

    Regards
    Reply With QuoteRegister To Reply
  5. 03-02-2019, 06:40 PM #5
    Ghozi Alkatiri
    Ghozi Alkatiri is offline
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: formula required to delete specific characters from between a lin

    =LEFT(A2,FIND("-",A2)-1)&TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2)))

    copy down
    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] How to delete cells and rows with specific Characters using VBA
    By priyadharshane in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 01-25-2019, 01:20 PM
  2. formula to delete word that contains number (VBA now required)
    By nlyrk0 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 03-27-2018, 08:39 AM
  3. [SOLVED] Macro to delete all characters after the second number 1 in specific cell
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-07-2018, 09:22 AM
  4. [SOLVED] Formula to Delete Text Between 2 Characters
    By Tellm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2015, 08:12 AM
  5. [SOLVED] Delete specific characters from right side of string
    By Drudnits1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-29-2014, 02:12 PM
  6. [SOLVED] If cell contains 3 or more specific characters then delete row
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2014, 08:12 AM
  7. formula to delete all but the last 3 characters
    By duugg in forum Excel General
    Replies: 2
    Last Post: 09-15-2006, 12:40 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