Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Moving text from one cell to another. | Excel Worksheet Functions | |||
how to hyperlink text to a cell | New Users to Excel | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |