Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 4

Alpha conditional statements

*east does not find Northeast in the following formula:-
=if(a1="*east",a1,"")
What am I doing wrong?
Office XP
Thanks, Dick W

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If Statements - Pick up Alpha Characters	Louise	Excel Discussion (Misc queries)	8	June 30th 08 03:30 PM
Conditional If Statements	maxcw	Excel Worksheet Functions	2	June 23rd 08 05:22 AM
Conditional statements	james	Excel Worksheet Functions	9	January 7th 08 03:07 PM
Conditional Statements	Robert Albrecht	Excel Discussion (Misc queries)	2	October 3rd 06 08:29 PM
The colums changed from alpha to numeric how do you make it alpha	worldmade	Excel Discussion (Misc queries)	2	May 26th 05 03:44 PM

All times are GMT +1. The time now is 11:17 PM.

About Us

"It's about Microsoft Excel"