Results 1 to 5 of 5

VB Code to condtionally find text and add Character

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-31-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    193

    VB Code to condtionally find text and add Character

    Hello:

    Please refer to attached file.
    I need VB Code to do following task.

    Look for text in column D which does not have text "Merchant" or "Deposit" and have Text "CR" in column F.
    Once found add text "CR in Front of the text (Column D)

    In attached file, I have highlighted 2 in column D which meets this criteria.

    So
    D5 = CR TAP & GO, LLC SENDER
    D12 = CR IRS USATAXPYMT

    I hope this is clear.

    Let me know if you have any questions.
    Thanks.
    R
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VB Code to find duplicate and add character
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-05-2021, 04:01 PM
  2. VB Code to find blank character
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2020, 10:41 PM
  3. [SOLVED] to find all the positons of character in a text which is unmatched with other text string.
    By Vivek2705 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-14-2019, 12:38 PM
  4. [SOLVED] VB Code to find row# with certain character
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-15-2016, 07:08 AM
  5. [SOLVED] Find text left or right of a specific character in a text string
    By Locopete99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-14-2014, 05:55 AM
  6. Replies: 4
    Last Post: 04-06-2014, 01:21 PM
  7. Macro to find character and delete all text in cell after the character
    By SpencerRichman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2012, 06:08 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1