assign

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"
<forum@nospam.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.*****-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
>

Michael

Thanks. I can use a helper column but I looked it over and tried to
understand but it might be too complicated for my limited excel knwledge.
I look at it again but i'm hoping there might be a simpler way.
Basically, I need to eliminate all the characters in the cell that aren't
numbers (letters and punctuation).

thanks.

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

Sorry about that Jeremy. I don't understand it myself. Maybe one of the
MVP's will come up with some VBA code for you.
--
Sincerely, Michael Colvin


"jeremy via OfficeKB.com" wrote:

> Michael
>
> Thanks. I can use a helper column but I looked it over and tried to
> understand but it might be too complicated for my limited excel knwledge.
> I look at it again but i'm hoping there might be a simpler way.
> Basically, I need to eliminate all the characters in the cell that aren't
> numbers (letters and punctuation).
>
> thanks.
>
> --
> Message posted via http://www.officekb.com
>