+ Reply to Thread
Results 1 to 3 of 3

Find / Replace Formula

  1. #1
    Registered User
    Join Date
    07-23-2005
    Posts
    23

    Find / Replace Formula

    Hello,

    I'm looking for a formula that will help me find specific words in a column and replace them with specific numbers. The example below shows a column with six populated cells.

    Column A
    - Account
    - Assitant Accountant
    - Accounting Manager
    - Teacher
    - Actor
    - Police

    Any cell that contains the word "Account", like the first 3 rows above, should be replaced with the number 6.

    - The entire field with "Assistant Accountant" would be replaced with 6
    - The entire field with "Accounting Manager" would be replaced with 6
    - The entire field with "Account" would be replaced with 6

    Any insight would be greatly appreciated.

    Thanks!

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Find / Replace Formula

    addie,

    In an empty column you could use this formula:
    =IF(COUNTIF(A1,"*account*")>0,6,A1)

    And then copy down. You have a few options after that, you could copy -> Paste Special -> Values into column A, or you could just hide column A, or you could leave things as is if that works for you.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    07-23-2005
    Posts
    23

    Re: Find / Replace Formula

    Thanks, Tigeravatar!

    It worked perfectly.

+ Reply to Thread

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