Results 1 to 5 of 5

Search Cells and Replace Text in that cell

Threaded View

lennonjunior Search Cells and Replace Text... 05-05-2009, 09:05 PM
JBeaucaire Re: Create VBA Script 05-05-2009, 09:36 PM
lennonjunior Re: Create VBA Script 05-05-2009, 10:29 PM
JBeaucaire Re: Create VBA Script 05-05-2009, 11:42 PM
shg Re: Create VBA Script 05-05-2009, 11:45 PM
  1. #1
    Registered User
    Join Date
    05-05-2009
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Search Cells and Replace Text in that cell

    I am very new to Macros and writing VBA scripts. Here is what I am wanting to do. Search multiple cells for certain string and then replace the text of the entire cell with new text.

    For example the text may contain:
    "A Chestnut Leather Satchel Binocular Case "They'll Fight Over When You're Dead" (Binocularcase-SL-CH)"

    I want to search for SL-CH and once that is found I want to replace the contents of the entire cell with the following:
    Satchel Chestnut (SL-CH)

    TIA
    Last edited by lennonjunior; 05-06-2009 at 03:58 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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