Forum Home
Press F1
Thread ID: 5289	2000-08-12 09:33:00	XL - Formula - If a cell contain just this text, display some other text in this cell.Check a cell	Guest (0)	Press F1

Post ID	Timestamp	Content	User
5834	2000-08-12 09:33:00	I would like a formula, that checks if a cell contains some of this text, display some other text in the next cell. Say I have Ford Explorer in cell A1(could be Ford Pinto or another Ford model), I need a formula in cell B2 which checks Cell A1 for the word Ford, then displays Petrol, but leaves it blank otherwise. Thanks....John	Guest (0)
1