Post Reply 
Spreadsheet - Extracting from List
03-16-2015, 08:37 AM (This post was last modified: 03-16-2015 08:42 AM by Thomas_Sch.)
Post: #2
RE: Spreadsheet - Extracting from List
Hello Dirk,
unfortunately the method to address an element in an list, like =B1(1) ist not working within spreadsheet.
=B1(1) does habe an other meaning in the conext of spreadsheet. See page 200 "Format parameters" in the english manual.

Now I've tried something weird, and =MAX(ASC(B1)) (or MIN) does the job, if you have only on character.
If B1 contains more characters, =MIN(CAS.left(ASC(B1),1)) delivers the ascii value off the first character.
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Spreadsheet - Extracting from List - Dirk. - 03-16-2015, 07:28 AM
RE: Spreadsheet - Extracting from List - Thomas_Sch - 03-16-2015 08:37 AM



User(s) browsing this thread: 2 Guest(s)