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. |
|||
« Next Oldest | Next Newest »
|
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
RE: Spreadsheet - Extracting from List - Dirk. - 03-16-2015, 09:05 AM
RE: Spreadsheet - Extracting from List / small error in spreadsheet app / - Thomas_Sch - 03-17-2015, 07:18 AM
RE: Spreadsheet - Extracting from List - Thomas_Sch - 07-10-2015, 06:30 AM
|
User(s) browsing this thread: 1 Guest(s)