+ Reply to Thread
Results 1 to 5 of 5

How to use Regexp to do it?

  1. 12-30-2017, 12:08 AM #1
    ikboy
    ikboy is offline
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    How to use Regexp to do it?

    This code is changes all commas only inside the brackets.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 12-30-2017, 01:41 AM #2
    than_gold
    than_gold is offline
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: How to use Regexp to do it?

    Hope this will help you:

    https://stackoverflow.com/questions/...cell-and-loops
    Regards,
    Thangavel D
    Appreciate the help? CLICK *
    Reply With QuoteRegister To Reply
  3. 12-30-2017, 10:59 AM #3
    ikboy
    ikboy is offline
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: How to use Regexp to do it?

    Hi than_gold,
    Can you write the pattern for me?
    Reply With QuoteRegister To Reply
  4. 12-30-2017, 01:25 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to use Regexp to do it?

    UDF?

    A
    B
    C
    2
    		 (a,bc,d)e,fg,hi,jk,l(m,mn,o) (a/bc/d)e,fg,hi,jk,l(m/mn/o) B2: =ikboy(A2) 


    Please Login or Register  to view this content.
    Last edited by shg; 12-30-2017 at 03:29 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  5. 01-04-2018, 02:16 AM #5
    ikboy
    ikboy is offline
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: How to use Regexp to do it?

    Solved by below code:
    Please Login or Register  to view this content.
    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. Formatting using Regular Expression (RegExp)
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2014, 10:03 AM
  2. [SOLVED] VBA RegExp
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2014, 05:45 PM
  3. [SOLVED] RegExp function
    By pkiula in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-17-2013, 06:22 AM
  4. Error with Set RegExp equal to New RegExp vba
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-22-2011, 05:28 PM
  5. VBScript.RegExp
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-27-2010, 09:20 PM
  6. RegExp
    By YBrazeau in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2010, 07:51 PM
  7. RegExp Pattern
    By MBCMDR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-08-2009, 02:09 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