+ Reply to Thread
Results 1 to 5 of 5

Find and replace font

  1. #1
    Forum Contributor
    Join Date
    09-09-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    102

    Find and replace font

    Hello,

    I am trying to replace Helvetica light with Aller light. The Helvetica light font is in one of the master slides but I cannot find where, I want to create a VBA to find and replace the font so I no longer receive the cannot embed font warning message every time I save the powerpoint. Any ideas? Is this possible?

    Thanks

    Z

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Find and replace font

    Not sure about power point, but you can use Find and replace to replace formats in Excel (Should be there in POwerPoint too)

    Ctrl+H > Find what & Replace What Boxes should be blank, On the 1st Format button, click on the drop down and select the cell with the format, and then in the second format button, set your desired format, and click on replace all.
    Cheers!
    Deep Dave

  3. #3
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Find and replace font

    On the Home tab, look on the right-hand side in the 'Editing' section. Click the little arrow beside the 'Replace' button and select 'Replace Fonts'. The top drop-down will list all the fonts in use in your presentation and the lower drop-down lists all fonts. Choose the one you want to replace (Helvetica) in the top box and the one you want instead (Aller) in the lower box.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  4. #4
    Forum Contributor
    Join Date
    09-09-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    102

    Re: Find and replace font

    Tried that already but I get a message 'You selected a single-byte font to replace a double-byte font. Please select a double-byte font.

    I cannot find where the text or textbox with helvetica light is. Thge template is rather large so I want a quick way of finding the helvetica text and replacing it. Thought vba may be the best best?

    Thanks for your help.

    Z

  5. #5
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Find and replace font

    Some suggestions found here: https://groups.google.com/forum/#!to...nt/Zch6fvhIKzQ
    I was trying to replace "Arial (Headings)" which apparently was a double byte font with "Arial" which was identified as a single byte font. After learning that Asian characters are generally double byte, I globally replaced "Arial (Headings)" with "AngsanaUPC", then globally replaced AngsanaUPC with plain old Arial and it worked!
    I exported the presentation as an XML. Opened the XML in notepad, Did a Find & Replace on the offending font and replaced with Arial. Saved. Reopened in PPT and saved back to PPT format.
    There's some other suggestions here too: http://www.pptfaq.com/FAQ00287_This_...-t_display.htm
    Solution 6 there has some VBA for replacing 'Far East' fonts - I expect if you replace 'NameFarEast' with 'Helvetica' it should work for you:
    Please Login or Register  to view this content.
    The final suggestion is this one:
    Save two copies of your presentation. Delete the first half of the slides from one, the second half from the other. Check each half to see if either has any reference to far east fonts. If it does, keep dividing in half this way until you've narrowed it down to just the slide or slides with the far-east fonts called for. Go back to your original presentation, re-create this slide or slides (not copy, re-create from scratch). Then delete the original slide.
    Hopefully one of those works for you.

+ 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] VBA to find red font, then find black font & paste that value next to the red font
    By Lewej23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2016, 05:18 PM
  2. Replies: 16
    Last Post: 12-02-2014, 03:38 PM
  3. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  4. [SOLVED] Excel macro- Find replace an itallic font word with a regular word?
    By thisisaboutwork in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2013, 01:48 PM
  5. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM
  6. [SOLVED] Find and replace of word causes change of font formatting
    By jwa90010 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 07-22-2005, 04:05 PM
  7. Find and replace font
    By light in forum Excel General
    Replies: 0
    Last Post: 01-13-2005, 02:12 PM

Tags for this Thread

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