Is it possible in Excel 97-03 to add a suffix and prefix to data that is already entered into a cell when you enter a predefined character into another cell.
For example:
A1 = "active"
if I enter a "y" in to A2 i would like to add a "-" to the beginning and end of the text in A1, so it would display A1 = "-active-".
Im am trying to do this in order to exclude this from other functions I have running on the sheet, maybe I am looking in the wrong place?
Hi,
You can't do this without a macro, but you could use a helper cell/column to derive the result, e.g.
HTH
=IF(A2="y","-active-","active")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
di22y 
Register To Reply
Bookmarks