+ Reply to Thread
Results 1 to 2 of 2

Adding a character before certain words in a column

  1. #1
    Registered User
    Join Date
    06-10-2014
    Posts
    1

    Adding a character before certain words in a column

    Hey, I'm pretty new to macros, its time I finally posted because I can't find a solution anywhere.

    I have a list of keywords in column F, for example

    black green blue
    yellow red pink
    orange silver black

    I would like to make a macro which turns that list of keywords into

    black +green +blue
    +yellow +red +pink
    +orange +silver black

    (in this case Ive chosen to exclude the word black)

    Any ideas? too many entries to do manually. Thanks!

  2. #2
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Kalgoorlie Australia
    MS-Off Ver
    Excel 2007/10
    Posts
    251

    Re: Adding a character before certain words in a column

    Hello M'
    Try this
    =if(or(f1=green,f1=blue,f1=yellow,f1=red,f1=pink,f1=orange,f1=silver)=true,"+"&f1,f1)
    Then copy down cells

    Regards
    Peter

+ 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: 3
    Last Post: 11-08-2012, 05:01 PM
  2. [SOLVED] Need to generate 3-character words from 3 columns
    By tmccar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2012, 07:13 AM
  3. Replies: 7
    Last Post: 02-15-2012, 05:58 AM
  4. Replies: 6
    Last Post: 05-24-2011, 07:16 AM
  5. Replies: 2
    Last Post: 03-16-2006, 09:53 AM

Tags for this Thread

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