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
Hi and welcome to the board
how does the first string become the second one?
hopefully with conditional formatting. the same way the standard formats work. (formatted for currency 5 in a cell be comes $5.00)
Yes I understand, but what part of the initial string should be found in the second?
I apologize for my typo (fixed in OP). the entire first string stays the same. just append ABC to the beginning.
Use =CONCATENATE("ABC",YourCellreference)
how do you do it if the cell reference is the same cell? I just want one cell where the data is entered and the prefix is automatically added when you press enter, like with cond. formatting.Originally Posted by darknation144
Last edited by jdmnash; 03-12-2012 at 01:19 PM.
Try this
="A"&$G$1
Note: G1=Cell Reference
Last edited by Fotis1991; 03-12-2012 at 01:55 PM. Reason: Note:
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
is there a way to do this with only conditional formatting? using a cell reference is not an option for me.
I'm afraid you will need VBA for this, which is not my forte
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks