Results 1 to 15 of 15

Macro to delete characters between 2 characters.

Threaded View

abjac Macro to delete characters... 09-29-2014, 04:14 AM
nathansav Re: Macro to delete... 09-29-2014, 04:19 AM
Richard Buttrey Re: Macro to delete... 09-29-2014, 05:23 AM
abjac Re: Macro to delete... 09-29-2014, 04:28 AM
nathansav Re: Macro to delete... 09-29-2014, 04:35 AM
abjac Re: Macro to delete... 09-29-2014, 04:44 AM
nathansav Re: Macro to delete... 09-29-2014, 04:47 AM
millz Re: Macro to delete... 09-29-2014, 04:47 AM
abjac Re: Macro to delete... 09-29-2014, 05:03 AM
abjac Re: Macro to delete... 09-29-2014, 05:42 AM
Richard Buttrey Re: Macro to delete... 09-29-2014, 06:15 AM
abjac Re: Macro to delete... 09-29-2014, 07:15 AM
Richard Buttrey Re: Macro to delete... 09-29-2014, 07:30 AM
abjac Re: Macro to delete... 09-29-2014, 08:29 AM
Richard Buttrey Re: Macro to delete... 09-29-2014, 08:48 AM
  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Macro to delete characters between 2 characters.

    HI I need help to make a macro to delete all characters between 2 characters.
    Thanks to PCI I have sorted allot out all ready, but need this general last thing.
    I Need a macro which will delete all characters after 74 from the left and the second - from the right.

    If I can have that I will manage to delete what I don't need.
    In below example I need this to be deleted which are in red.
    C:\Documents and Settings\Alancecille\Desktop\torrents\Karaoke songs\ 0002 --thm - Ig Joe Turner - Shake Rattle & Roll.zip
    C:\Documents and Settings\Alancecille\Desktop\torrents\Karaoke songs\ 0003 ps12520 - Jerry Lee Lewis - Great Balls Of Fire.zip
    C:\Documents and Settings\Alancecille\Desktop\torrents\Karaoke songs\ 0004 jkdjk -- - Jimmy Buffett - Margaritaville.zip

    P.s The macro has to work in column B start from B2 all the way down


    Please have a look. I need a macro because it have to be used with other macros.

    Thanks in advance

    Sincerely
    Abjac
    Last edited by abjac; 09-29-2014 at 04:17 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to delete row if the first characters are numbers
    By Ilwuen in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-20-2014, 05:14 PM
  2. [SOLVED] Delete characters and add * in front and last characters in ACCESS QUERY
    By LALTIZER in forum Access Tables & Databases
    Replies: 9
    Last Post: 02-01-2013, 02:06 PM
  3. [SOLVED] Characters.delete only works with less than 255 characters?
    By mexindian in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2012, 11:57 AM
  4. Macro to Delete all but first 3 characters
    By megdawom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2011, 07:46 PM
  5. macro to delete all characters in a row before @ character
    By chcal301 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2005, 04:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1