+ Reply to Thread
Results 1 to 4 of 4

Macrto to change a word in a column

  1. 05-21-2014, 06:11 PM #1
    Roofer
    Roofer is offline
    Registered User
    Join Date
    01-10-2014
    Location
    Wis USA
    MS-Off Ver
    2013
    Posts
    10

    Macrto to change a word in a column

    How can I create a macro that if any word in column D says Main to change that word to Shop
    Reply With QuoteRegister To Reply
  2. 05-21-2014, 06:21 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    re: Macrto to change a word in a column

    How about just using Find and Replace?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 05-22-2014, 12:37 PM #3
    Roofer
    Roofer is offline
    Registered User
    Join Date
    01-10-2014
    Location
    Wis USA
    MS-Off Ver
    2013
    Posts
    10

    Re: Macrto to change a word in a column

    Oh,

    Thanks, That was simple.
    Reply With QuoteRegister To Reply
  4. 05-22-2014, 12:44 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Macrto to change a word in a column

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro if data in column a = set word to insert that column into sheet 2 or 3 based on word
    By ExcelBeginner326 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-13-2014, 01:57 PM
  2. VBA to enter a word, find said word in string of column & copy to another column
    By tuneloon in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-29-2012, 11:59 AM
  3. [SOLVED] If change in one column using specific word, then copy row to another tab, repeat.
    By mastro78 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-18-2012, 12:16 PM
  4. Possible to change single word font/color in multiple cells in same column???
    By androidbill143 in forum Excel General
    Replies: 3
    Last Post: 03-05-2012, 11:03 AM
  5. Find a Word in Column A & change the background & Text to Black
    By ADSK in forum Excel General
    Replies: 3
    Last Post: 06-06-2009, 12:17 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1