View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marin[_2_] Marin[_2_] is offline
external usenet poster
 
Posts: 8
Default Excel check value i cell

On Wednesday, February 20, 2013 5:17:09 PM UTC+1, Claus Busch wrote:
Hi Marin,



Am Wed, 20 Feb 2013 08:04:55 -0800 (PST) schrieb Marin:



iam from Croatia, EU.


so maybe problem is cause regional setting... who knows




it could be the separator. Change the commas to semikolons.

Does it work?





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2


yes!
thing is working
i import this:
=CHOOSE(LEFT(A2;4)-3009;"Street";"Block";"Town")

thx once again. iam so happy now