RE: 1=City, 2=Roskill

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Rowan" <Rowan@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 15 Aug 2005 18:16:09 -0700

=IF(LEFT(A1)="1","City",IF(LEFT(A1)="2","Roskill",""))

Regards
Rowan

"Steved" wrote:

> Hello from Steved
>
> I would like to please use only the first number as a identifier.
>
> for example 1234, 1543, 1789, 1673 in this case the 1 will = City
> for example 2234, 2543, 2789, 2673 in this case the 2 will = Roskill
>
> Thankyou.
.

Follow-Ups:
- RE: 1=City, 2=Roskill
  - From: Steved
- RE: 1=City, 2=Roskill
  - From: Steved

References:
- 1=City, 2=Roskill
  - From: Steved

Prev by Date: RE: 1=City, 2=Roskill
Next by Date: Re: How do I use wild cards in nested array formulas?
Previous by thread: RE: 1=City, 2=Roskill
Next by thread: RE: 1=City, 2=Roskill
Index(es):
- Date
- Thread

Relevant Pages

RE: How can I dynamically change the range for Range("A1:M500")?
... Regards ... Rowan ... >>> Reason I want to do this is because I want to set my print area in VB. ... Prev by Date: ...
(microsoft.public.excel.programming)
Re: lock a range question
... > You could simplify the first one with ... >> rowan: ... Prev by Date: ...
(microsoft.public.excel.programming)
Copy Method
... while this one produces runtime error 1004 ... Regards ... Rowan ... Prev by Date: ...
(microsoft.public.excel.programming)
Re: Insert Textbox values to seperate rows/columns
... Rowan, ... Regards, ... Shane Thompson ... Prev by Date: ...
(microsoft.public.excel.programming)
RE: 1 will be City, 2 will be Roskill and so on please.
... Regards, ... Ashish ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)