j844929
Active Member
- Joined
- Aug 18, 2002
- Messages
- 423
Hi,
Does anyone know if there is a way of writing a formula that will show certain values depending upon the first piece of text in another cell...?
What I'd like to do, is the following:
IF cell A1 begins with C, replace 'C' with 'T' can it be done? (There are only ever two characters in the cell. I can do it so that no matter what the cell begins with, it is replaced with a 'T', but I need to make it conditional...
Any suggestions would be appreciated.
Does anyone know if there is a way of writing a formula that will show certain values depending upon the first piece of text in another cell...?
What I'd like to do, is the following:
IF cell A1 begins with C, replace 'C' with 'T' can it be done? (There are only ever two characters in the cell. I can do it so that no matter what the cell begins with, it is replaced with a 'T', but I need to make it conditional...
Any suggestions would be appreciated.