+ Reply to Thread
Results 1 to 9 of 9

Find and Replace Problem

  1. #1
    Registered User
    Join Date
    04-01-2014
    Location
    Allen TX. (Dallas)
    MS-Off Ver
    2007
    Posts
    30

    Find and Replace Problem

    A couple of issues.

    1. I can't paste the text into the Find & Replace box

    2. I think someone was able to paste it in the Find & Replace box but than it would not Find & Replace.


    Find this

    <strong>**Order items based on <u>Title and Part Number</u>. Photos are for illustration purposes <u>Only</u>.</strong></p>

    <p><strong>**Seller is not responsible for part fitment based on Ebay's or EPID's compatibility chart. <br /></strong></p>

    <p><strong>**Buyer should verify Part Fitment with manufacturer.</strong></p>


    Replace with this

    <strong>**Order items based on <u>Title and Part Number</u>. Photos are examples <u>Only</u>.</strong></p>

    <p><strong>**Seller is not responsible for part fitment<br /></strong></p>

    <p><strong>**Please Part Fitment with manufacturer.</strong></p>


    Find this so I can delete it with a space in the replace field

    <p class="" align=""><strong><em>We do not ship outside the USA Lower 48 States, PO Boxes or Military address, only to addresses where Fedex or UPS will delivery.</em></strong></p>

    <p align="">&nbsp;</p>

    <p align="">&nbsp;</p>

    <p align=""><em>We sell these in other venues and at times we may have inventory shortages, if that occurs we will refund your monies promptly, thank you for understanding.</em><strong>If you have an inventory question please send us an email.</strong></p>

    <p align="">&nbsp;</p>

    <p align=""><em>When rating the Ebay Feedback STARS please rate those pertaining to <strong>our performance</strong>, if you did not like the product the feedback area is not the place as we do not manufacture the product, we just resell it. Unfortunately, Ebay removes discounts and which causes us to increase the price with anything less than 5 Stars. </em></p>

    <p>&nbsp;</p>

    <p>&nbsp;</p>

    <p><strong><em>Policies:</em></strong></p>

    <p>&nbsp;</p>

    <p><strong><em><!--?xml:namespace prefix = o ns = ""urn:schemas-microsoft-com:office:office"" /--><!--?xml:namespace prefix = o /-->&nbsp;</em></strong></p>

    <p>&nbsp;</p>

    <p><strong><em>Shipping </em></strong></p>

    <ul type="">

    <li class=""><em>Please allow 1-2 business days for processing.</em></li>

    <li class=""><em>We do not ship outside the lower US 48 States</em></li>

    <li class=""><em>No shipping to APO/FPO,PO Boxes, Alaska, Hawaii or Puerto Rico</em></li>

    </ul>

    <p>&nbsp;</p>

    <p class=""><strong><em>Tracking</em></strong></p>

    <ul type="">

    <li class=""><em>Tracking will be posted to your account as soon as we receive from our warehouse, UPS, Fedex, etc.</em></li>

    </ul>

    <p>&nbsp;</p>

    <p class=""><strong><em>Products</em></strong></p>

    <ul type="">

    <li class=""><em>All products are New unless otherwise noted</em></li>

    <li class=""><em>We do not sell refurbished, seconds or blems.</em></li>

    <li class=""><em>We welcome all questions but specific question might be better answered by the mfg. </em></li>

    </ul>

    <p>&nbsp;</p>

    <p class=""><strong><em>Returns</em></strong></p>

    <ul type="">

    <li class=""><em>Please email for a RMA</em></li>

    <li class=""><em>To help eliminate returns please ask Any question you may have</em></li>

    <li class=""><em>Returns are sometimes needed, in that event items Must be returned in the original condition, box, packaging and paperwork. </em></li>

    <li class=""><em>We are unable to resell items not in the original condition</em></li>

    <li class=""><em>We do not refurbish product and resell, returns must be in the State of New. </em></li>

    </ul>

    <p>&nbsp;</p>

    <p class=""><strong><em>Contact Us</em></strong></p>

    <ul type="">

    <li class=""><em>If you have questions please email and we will answer as quick as possible M-F 9:30-4:30 CST, we do not work on the weekend</em></li>
    Attached Files Attached Files
    Terry

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Find and Replace Problem

    F/R will only take 255 chr's. You are trying to find 327
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    04-01-2014
    Location
    Allen TX. (Dallas)
    MS-Off Ver
    2007
    Posts
    30

    Re: Find and Replace Problem

    Okay, that is making sense, is there another way to accomplish this? I have about 25,000 items this needs to be done on at once.

  4. #4
    Registered User
    Join Date
    03-30-2014
    Location
    Pittsburgh,PA
    MS-Off Ver
    Office 2010, Home Student 2013
    Posts
    62

    Re: Find and Replace Problem

    If you absolutely must edit HTML in Excel, do the Find & Replace in smaller chunks. For example,

    Find: Photos are for illustration purposes
    Replace: Photos are examples

    Find: Seller is not responsible for part fitment based on Ebay's or EPID's compatibility chart.
    Replace: Seller is not responsible for part fitment.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Find and Replace Problem

    Another option would be to use a helper column, and use =SUBSTITUTE()

    Put your FIND in 1 cell, your REPLACE in another...
    =SUBSTITUTE(A1,$C$2,$D$2)
    I put FIND in C2 and REPLACE in D2

    If this works for you, you could then copy/paste values from the helper, back over the original data - and then delete the helper

  6. #6
    Registered User
    Join Date
    04-01-2014
    Location
    Allen TX. (Dallas)
    MS-Off Ver
    2007
    Posts
    30

    Re: Find and Replace Problem

    I am not familiar how to do the substitute but I will give it a shot.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Find and Replace Problem

    It is a formula that you enter into another cell, and it "substitutes" 1 string for another string. String length is not an issue with it

  8. #8
    Registered User
    Join Date
    04-01-2014
    Location
    Allen TX. (Dallas)
    MS-Off Ver
    2007
    Posts
    30

    Solved Re: Find and Replace Problem

    Appears to be working, didn't know how to mark this thread as solved.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Find and Replace Problem

    Looks like you figured that out too

    thanks for the feedback

+ 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. VBA for Find and Replace problem
    By rbaughman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2014, 07:35 PM
  2. Find & replace problem..
    By Jhon Mustofa in forum Excel General
    Replies: 1
    Last Post: 03-20-2014, 05:17 AM
  3. Find and replace problem
    By goldie.mctraveller in forum Excel General
    Replies: 1
    Last Post: 06-14-2012, 10:11 PM
  4. Problem with find and replace
    By Reema in forum Word Formatting & General
    Replies: 2
    Last Post: 04-14-2009, 03:17 AM
  5. [SOLVED] Problem with Find and Replace
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM
  6. Problem with Find and Replace
    By mjhill01 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. Problem with Find and Replace
    By mjhill01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2005, 12:05 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