Search
Member List
Calendar
Help
HP Forums
/
HP Calculators (and very old HP Computers)
/
HP Prime 
/
Spreadsheet - Extracting from List
/
Spreadsheet - Extracting from List
|
Spreadsheet - Extracting from List
|
|
03-16-2015, 07:28 AM
Post: #1
|
|||
|
|||
|
Spreadsheet - Extracting from List
Using the ASC()-function in the spreadsheet, e.g. =ASC(B1) in D1, leads to {78} when there is "N" in B1. To further process this result I need 78, not {78} but I did not find a way to get the first element of the list. Is it somehow possible without writing a "user function"?
Greetings from the River Lahn, Dirk. |
|||
|
|
« 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)