Excel Hints

Results 1 to 8 of 8

Thread: Replace hyphen with non-breaking hyphen

  1. #1

    Replace hyphen with non-breaking hyphen

    I need to replace all hyphens in a presentation with a non-breaking hyphen.

    I know that I can manually insert a non-breaking hyphen by using Alt+0173, but I can't figure out how to do that in a search and replace macro.

    Any help would be greatly appreciated!

  2. #2
    You shouldn't need a macro just the standard replace item. Copy and paste a non breaking hyphen into the replace with box.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  3. #3
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    Yeah... it won't look like anything is pasted in the REPLACE area, but try it. It actually works.
    Office 2010, Windows 7
    goal: to learn the most efficient way

  4. #4
    Thanks Tom, I should have mentioned that
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  5. #5
    You can directly type the Alt+0173 (using the NumPad) in the "Replace With:" box, so you don't need to copy one

    Paul

  6. #6
    That true. I'm using a laptop with no numeric pad so it's more tricky to use Num Lock to add it so I use insert symbol and copy / paste
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  7. #7
    MS Word has much more powerful S&R capability, wildcards, formatting, etc.

    I wish PP also had that power, or that some clever PP VBA programmer could provide a macro that emulates the Word S&R capability.

    Paul

  8. #8
    Quote Originally Posted by Paul_Hossler
    MS Word has much more powerful S&R capability, wildcards, formatting, etc.

    I wish PP also had that power, or that some clever PP VBA programmer could provide a macro that emulates the Word S&R capability.

    Paul
    I have a S/R functionality I built in VBA that I use, although it's not complete enough to share (there are a few things I haven't finished that I want to tweak - if I ever get the time). It doesn't do wildcards just yet, but it allows changing the text attributes (Font, Superscript, Font size, etc.); it can limit the search to specific areas (selection, custom slide shows, notes/master/handout pages, etc). IF I ever get the chance to get it finished, I might look into releasing it as a shareware add-in for a small fee.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •