Results 1 to 10 of 10

Conditional formatting - text prefix with text contents

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    the office
    MS-Off Ver
    Excel 2007
    Posts
    5

    Conditional formatting - text prefix with text contents

    Is it possible to prefix text in a range of cells with a conditional format using the available wildcards?

    example:
    contents: 3KJ3L
    becomes: ABC3KJ3L

    the prefix must be appended automatically when data is entered. (any example where you enter a formula in column B for contents in column A will not work for my application.
    Last edited by jdmnash; 03-12-2012 at 12:48 PM. Reason: TYPO

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