+ Reply to Thread
Results 1 to 20 of 20

Macro to delete consonants

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,709

    Macro to delete consonants

    s
    s
    aiks
    ls
    s
    s
    s
    ehk

    s
    s
    os
    s
    ns
    s
    s

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,709

    Re: Macro to delete consonants

    I have that on a1 as raw data , i want the macro to delete all consonants and remains with vowels

  3. #3
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to delete consonants

    ------------------Deleted
    Last edited by Sintek; 04-09-2017 at 11:02 AM. Reason: Found error in code
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Macro to delete consonants

    5B:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    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

  5. #5
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to delete consonants

    @ karedog

    Please put me out of my misery.....Assume that the information was in Column A1 down and not just in A1 so i.e A1 = "s", A2 = "s" A3 = "aiks" etc
    How does this code have to be altered to work.
    Please Login or Register  to view this content.

  6. #6
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to delete consonants

    @ karedog

    I was trying to make use of MickG's code for the post problem and could not even get that to work.
    Please Login or Register  to view this content.

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Macro to delete consonants

    Are you sure you should be using Len("A" & i) in the inner loop?
    If posting code please use code tags, see here.

  8. #8
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to delete consonants

    @ Norie

    I dunno...I'm lost....Being trying to figure out why !!!!

    I'm trying to loop through A & i then loop through the characters of A & i

  9. #9
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Macro to delete consonants

    Is it the characters in the string A & i you want to loop through or the characters in the string in Range("A" & i)?

    PS When deleting it's normally a good idea to loop backwards.

  10. #10
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to delete consonants

    Hi Norie

    the characters in the string in Range("A" & i)

  11. #11
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Macro to delete consonants

    So this,
    Please Login or Register  to view this content.
    should be this.
    Please Login or Register  to view this content.

  12. #12
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to delete consonants

    Oh my gosh...Really....Still so much to learn...Would never have figured that out...
    So code that works if info was in column...Thanks Norie
    Please Login or Register  to view this content.

  13. #13
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to delete consonants

    And MickG's code to solve the thread problem
    Please Login or Register  to view this content.

  14. #14
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Macro to delete consonants

    This UDF might work

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  15. #15
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Macro to delete consonants

    @sintek,
    Sorry for the late, but I see you have figured it out by yoursef. Good job.

  16. #16
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Macro to delete consonants

    Quote Originally Posted by karedog View Post
    5B:
    Please Login or Register  to view this content.
    Should be
    Please Login or Register  to view this content.
    otherwise it leaves pipe.
    Quote Originally Posted by sintek View Post
    Please Login or Register  to view this content.
    Should be
    Please Login or Register  to view this content.
    it also leaves comma.

  17. #17
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Macro to delete consonants

    Quote Originally Posted by jindon View Post
    Should be
    Please Login or Register  to view this content.
    otherwise it leaves pipe.
    Thanks for correction, forget it is inside square brackets.

  18. #18
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,709

    Re: Macro to delete consonants

    What is the final version , to pick , that will do the needful

  19. #19
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,336

    Re: Macro to delete consonants

    I would go for this one.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  20. #20
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to delete consonants

    Quote Originally Posted by jindon View Post
    Should be
    Please Login or Register  to view this content.
    it also leaves comma.
    Thanks 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. [SOLVED] looking for words with joint consonants
    By makinmomb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-28-2017, 12:21 AM
  2. Run Macro Automatically When delete row , changes cell,delete column
    By elevisse in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2012, 07:42 AM
  3. Macro to delete certain columns and delete rows based on time in another column
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2012, 11:47 AM
  4. [SOLVED] to separate the vowels and the consonants of a word.
    By gencoglu27 in forum Excel General
    Replies: 4
    Last Post: 12-26-2011, 05:02 PM
  5. [SOLVED] Macro to delete sheets and saves remaining file does not properly delete module
    By pherrero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2005, 08:12 PM
  6. [SOLVED] Re: Macro to delete sheets and saves remaining file does not properly delete module
    By bhawane in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2005, 01:05 PM
  7. [SOLVED] Re: Macro to delete sheets and saves remaining file does not properly delete module
    By pherrero in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2005, 01:05 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