How do I test a cell for part of text

E

East London

How can I test only part of the text in a cell and if true return value of a
different cell
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Excel does not accept text format! 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
VBA word change keys 0
Creating Labels Over 3-Up Image 2
Testing a cell value for a specific weekday. 4
using an IF or AND function to get next largest value in list 1
Quick Parts and Formatting Question 1

Top