|
| 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
January 26th, 2005, 11:15 AM
|
|||
|
|||
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
January 26th, 2005, 11:36 AM
|
|||
|
|||
|
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 |
Linear Mode
