+ Reply to Thread
Results 1 to 10 of 10

Find text in html

  1. #1
    Registered User
    Join Date
    05-21-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    10

    Find text in html

    Hi
    I am trying to use the find and replace formua, but the text i am trying to find is in a hmtl block in a cell and cannot find it.
    Is there a way to find it ?
    Many thanks for suggestions

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Find text in html

    This is especially for people with a glaz ball. Place an example file.

  3. #3
    Registered User
    Join Date
    05-21-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    10

    Re: Find text in html

    I have tried on 3 browsers and it wont let me :

  4. #4
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Find text in html

    Click on Go Advanced. Scroll down en click on Manage Attachments.

  5. #5
    Registered User
    Join Date
    05-21-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    10

    Re: Find text in html

    Yeah done that, it is the actual attatchment link on the page does not open properly, just a small narrow box and the text area flashes. Same on all browsers.
    Preview says it has worked
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-21-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    10

    Re: Find text in html

    In the description area i am looking for the words PRODUCT DESCRIPTION, but it cannot find it


    Attachment 631091

  7. #7
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Find text in html

    Don't know what you tried, but
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    works for me to find the position of the search string, that should get you to the point you need for the replace formula.

    If you need further assistance then we would need a bit more information (replace what with what?).

  8. #8
    Registered User
    Join Date
    05-21-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    10

    Re: Find text in html

    I am tryinh to replace with the text in column "c"
    thanks for help

  9. #9
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Find text in html

    See if this helps
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    please be aware that the text to replace (in red) is case sensitive.

  10. #10
    Registered User
    Join Date
    05-21-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    10

    Re: Find text in html

    works great, thankyou

+ 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. Replies: 2
    Last Post: 01-20-2018, 09:59 AM
  2. Find and replace html
    By andyh72 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2016, 07:40 AM
  3. [SOLVED] Formula to find the second jpg URL from the HTML script
    By kevivu in forum Excel General
    Replies: 4
    Last Post: 12-14-2015, 06:17 AM
  4. VBA to open saved web html pages - extract text - paste text within individual cell
    By EddieRubi in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-23-2015, 01:43 PM
  5. [SOLVED] Add text into HTML Text area of a website on click using VBA
    By Policeme21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2012, 08:09 PM
  6. convert formated excel column to html source text with html tags
    By julia81 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2011, 04:22 PM
  7. Pasting HTML formatted text as plain text in Excel
    By JeffCutter in forum Excel General
    Replies: 1
    Last Post: 09-21-2007, 07:43 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