+ Reply to Thread
Results 1 to 5 of 5

Macro to remove the first two characters

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    1,129

    Macro to remove the first two characters

    I have written code to extract the first two characters in Col A which happens to be 2 asterisks

    I have attached sample data

    I get type mismatch & the following code below is highlighted


    Please Login or Register  to view this content.
    See full code below

    Please Login or Register  to view this content.

    It would be appreciated if someone could assist me
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Arrow Re: Macro to remove the first two characters


    Hi,

    to remove the first characters just use the VBA Mid statement

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,128

    Re: Macro to remove the first two characters

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    1,129

    Re: Macro to remove the first two characters

    thanks for the advice Marc

  5. #5
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    1,129

    Re: Macro to remove the first two characters

    Thanks for the help, Jindon

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro to remove text after 250 characters?
    By wonderd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-27-2015, 01:09 PM
  2. [SOLVED] Formula or macro to remove characters between date
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2014, 12:35 PM
  3. Macro to remove certain characters end of a cell value
    By mergleh in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-09-2014, 05:19 PM
  4. Macro to remove characters preceding text descriptions
    By agent.orange in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2014, 06:32 AM
  5. remove spaces and characters in hyperlink - macro
    By missy22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2013, 09:23 AM
  6. [SOLVED] Macro to remove multiple characters in column?
    By emil9216 in forum Excel General
    Replies: 3
    Last Post: 07-31-2012, 09:29 AM
  7. Macro to remove any numeric characters from just the last value
    By Renfield in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2010, 12:03 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1