+ Reply to Thread
Results 1 to 5 of 5

Delete labels to images without deleting the images!

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Delete labels to images without deleting the images!

    I have a word document with about 250 images and each one having a text label. Each label is a standard line of text. What is the fastest way to select and delete the text in the document without deleting the images?

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Delete labels to images without deleting the images!

    Here is a link to a blog showing two examples of code that removes text added to images in Word. Hopefully one fits your scenario.

    Removing Captions from Images
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Delete labels to images without deleting the images!

    Neither macro worked, they both brought up a line error. I uploaded an example of what I am working with.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Delete labels to images without deleting the images!

    This should work for AltText part. Since the solutions offered in the link above did not work, I guess maybe you want to remove the alt text. If not, please say what error do you receive exactly, on which line of which code in that link above.
    Please Login or Register  to view this content.
    Last edited by Mrrrr; 02-17-2020 at 02:05 AM.
    To show your appreciation
    Click ★ Add reputation!

  5. #5
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Delete labels to images without deleting the images!

    Use a wildcard Find/Replace, where:
    Find = <*^13
    Replace = nothing.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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. Fetch images from google images using serial number in sheet
    By compmecca in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-11-2018, 08:08 AM
  2. Replies: 2
    Last Post: 07-25-2016, 03:39 AM
  3. Replies: 1
    Last Post: 04-13-2016, 08:46 AM
  4. Replies: 2
    Last Post: 12-08-2014, 06:04 AM
  5. Replies: 0
    Last Post: 01-01-2014, 04:36 PM
  6. Replies: 2
    Last Post: 06-18-2013, 12:15 PM
  7. [SOLVED] Swap images depending on text in cell (vlookup for images??)
    By ld2x07 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-06-2013, 10:32 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