Search:

Type: Posts; User: abramo; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Excel macro to find words in all caps then surround them in an html tag (e.g., and

    Many thanks!


    Steady there - there may be minors reading.
    (^joke ;) )


    Jokes apart, as in life : need to compromise. Perfectionism kills. While compromise is a hard pill to swallow, saves...
  2. Re: Excel macro to find words in all caps then surround them in an html tag (e.g., and

    Many thanks - took just minutes to test/verify that code at #20 in conjuction with #23 performs as advertised. Perfect! Took longer to study its workings, but was immdediately apparent this is a...
  3. Re: Excel macro to find words in all caps then surround them in an html tag (e.g., and

    Never fails to amaze us all regarding the perpetual stamina/patience/helpfulness/community spirit along with knowledge of @Peter_SSs , @Rick Rothstein & some other old guns at MrExcel.com. While...
  4. Re: Excel macro to find words in all caps then surround them in an html tag (e.g., and

    Any help appreciated.
    .
  5. Re: Excel macro to find words in all caps then surround them in an html tag (e.g., and

    Not really - the alternative version "leaving any items smaller than 3 characters unchanged" does not work as required. Sorry!
    Confused, no idea.

    .
  6. Re: Excel macro to find words in all caps then surround them in an html tag (e.g., and

    Meh! how silly of me, obvious mistake corrected - here is an alternative version "leaving any items smaller than 3 characters unchanged" that does work!


    Sub ConvertUppercaseWordsToProper()

    ...
  7. Re: Excel macro to find words in all caps then surround them in an html tag (e.g., and

    Nah! alternative version "leaving any items smaller than 3 characters unchanged" does not really work (embarrassed!)
    Any help with that?
    Thanks!

    .
  8. Re: Excel macro to find words in all caps then surround them in an html tag (e.g., and

    Hello @Peter_SSs - and thanks.
    Example of text in cell:



    BEAUTIFUL DAY is it NOT. We are GOING to have a nice TIME.

    Result:
  9. Re: Excel macro to find words in all caps then surround them in an html tag (e.g., and

    To anybody reading this, greetings.

    I wonder whether a new thread should be started, or not, regarding modification of @Peter_SSs at #4 - to satisfy a different end requirement.

    In...
  10. Macro to remove duplicate text within a cell

    Here below are duplicate text cases, in degree of importance:


    apple apple some text glass glass

    Both solutions kindly contributed do the job.
    In real life the above alternative, without...
  11. Macro to remove duplicate text within a cell

    Here below are duplicate text cases, in degree of importance, as needed for my application:
  12. Re: Convert Formula to Sub : Macro to remove duplicate text within a cell

    @Rick : Going for a maximum of 4 words in duplicate phrases would cover 99% of expected duplicates. Even 3 words would cover a large percentage.
  13. Re: Convert Formula to Sub : Macro to remove duplicate text within a cell

    @Rick : Thanks - regarding complication of phrases, I had not realised it was complicated to this extent, as I know truly little about coding. Going for a maximum of 4 words in phrases would cover...
  14. Re: Convert Formula to Sub : Macro to remove duplicate text within a cell

    @Rick : Thanks -- sure, suggested solution (without keeping any punctuation) will do fine for this application, as it is not so "demanding" in this respect.

    .
  15. Re: Convert Formula to Sub : Macro to remove duplicate text within a cell

    @Rick : thanks -- you got me there, but it would not spoil a vast eternal plan if we kept the first instance, in whatever form it happens to come -- in real life, on "average" the first instance of...
  16. Re: Convert Formula to Sub : Macro to remove duplicate text within a cell

    @Rick : thumbs up for a truly kosher solution!
    Needless to say, works as advertised.

    Hope it will be possible to apply this to adjacent identical "short phrases", punctuation marks and plurals?
    ...
  17. Re: Convert Formula to Sub : Macro to remove duplicate text within a cell

    @AlphaFrog : you are my hero! suggested macro works perfect.


    Dare I now introduce some "nuances" to the required solution?
    (OP now wearing helmet as precaution)

    - duplicate text term not...
  18. Convert Formula to Sub : Macro to remove duplicate text within a cell

    I have kindly been provided the following Formulas, each intended to remove duplicate text within a individual cells in a selected column. I would appreciate if these were incorporated in Sub macro...
Results 1 to 18 of 18