+ Reply to Thread
Results 1 to 6 of 6

MACRO TO REMOVE parenthesis and number

  1. 04-16-2017, 11:33 AM #1
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    MACRO TO REMOVE parenthesis and number

    Hi All

    I am looking a macro to remove parenthesis from an export interface data ,the issue it is long as 10000 rows

    Just to insert country of origin in a new column and remove the parenthesis and numerical data
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-16-2017, 11:42 AM #2
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: MACRO TO REMOVE parenthesis and number

    5B:
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  3. 04-16-2017, 11:52 AM #3
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: MACRO TO REMOVE parenthesis and number

    Thank you works as requested
    Reply With QuoteRegister To Reply
  4. 04-16-2017, 11:55 AM #4
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: MACRO TO REMOVE parenthesis and number

    You are welcome, thanks for the rep.points.

    Regards
    Reply With QuoteRegister To Reply
  5. 04-16-2017, 09:10 PM #5
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,522

    Re: MACRO TO REMOVE parenthesis and number

    JEAN1972

    No loop required...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 04-18-2017, 01:05 AM #6
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: MACRO TO REMOVE parenthesis and number

    Thank you for this solution Jindon
    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] Formula to remove a string and parenthesis in excel
    By rkulasekaran in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-08-2015, 06:39 AM
  2. [SOLVED] Remove nos not inside parenthesis
    By long8484 in forum Excel General
    Replies: 3
    Last Post: 05-13-2015, 09:19 AM
  3. [SOLVED] Need to remove parenthesis from a phone number and commas from figures
    By brlcarol in forum Excel General
    Replies: 9
    Last Post: 05-28-2014, 04:14 PM
  4. [SOLVED] Remove spaces before and after parenthesis and hash
    By abraham30 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2013, 10:32 AM
  5. remove value inside parenthesis visual basic
    By paynod in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-13-2012, 08:24 AM
  6. remove data in parenthesis
    By HuskerBronco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-24-2008, 03:48 PM
  7. [SOLVED] How do I format a negative number in parenthesis?
    By John Nollett in forum Excel General
    Replies: 10
    Last Post: 01-07-2006, 11:40 AM

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