How do I make every thin in a column that is not 4000 assigned the "0" and
every cell 4000 assigned the "1" (and ignoring the letters)?

column might look like

4002
AB009
4001ab
2004
0078
45

--
Message posted via http://www.officekb.com

Are there always just 2 letters (or none)?

On Tue, 07 Jun 2005 17:32:03 GMT, "jeremy via OfficeKB.com"
wrote:

How do I make every thin in a column that is not 4000 assigned the "0" and
every cell 4000 assigned the "1" (and ignoring the letters)?

column might look like

4002
AB009
4001ab
2004
0078
45

These are project numbers--some of them have letters in front and behind,
some don't. I need to assign all of the number into 5 categories....
Make sense?

--
Message posted via http://www.officekb.com

jeremy via OfficeKB.com wrote:
These are project numbers--some of them have letters in front and behind,
some don't. I need to assign all of the number into 5 categories....
Make sense?

No. The question was

"Are there always just 2 letters (or none)?"

Alan Beban

Sorry...it looks like always 2 letter (before or after). Another problem
is that ofter the number have an apostrophy (sp?) in front....

--
Message posted via http://www.officekb.com

Hi Jereemy.
If you can use a helper column to first extract the numeric part of your
text before applying your test, the following site may be of use:
http://www.dicks-blog.com/archives/2...rmulas-part-1/
HTH
--
Sincerely, Michael Colvin


"jeremy via OfficeKB.com" wrote:

Sorry...it looks like always 2 letter (before or after). Another problem
is that ofter the number have an apostrophy (sp?) in front....

--
Message posted via http://www.officekb.com