If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I test a cell for part of text
How can I test only part of the text in a cell and if true return value of a
different cell |
#2
|
|||
|
|||
Use the LEFT, MID or RIGHT functions.
Eg A = ABCDEF =IF(LEFT(A1,2)="AB", =IF(MID(A1,2,2)="BC", iF(RIGHT(A1,3)="DEF", -- HTH RP (remove nothere from the email address if mailing direct) "East London" East wrote in message ... How can I test only part of the text in a cell and if true return value of a different cell |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to test the text font color in a cell | Yves | General Discussion | 4 | September 12th, 2004 11:00 PM |
Keeping text formatting when referencing a text cell | Posty | General Discussion | 4 | July 22nd, 2004 02:39 PM |
How do I get text in cell a depending on text in cell b? | Frank Kabel | Worksheet Functions | 3 | March 30th, 2004 03:31 PM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
if statement - text / blank cell | jester | Worksheet Functions | 5 | November 3rd, 2003 01:28 AM |