I’ve used several spreadsheets, including yours. When I type “=left(a4)” I hoped to get a number representing the length of the text string located at A4. All I get is the formula, and I can’t figure out how to get around this. I’ve typed the formula directly and I’ve constructed it with the wizard, same result.
what spreadsheet is named as “yours” here? i’m curious if the poster confuses spreadsheets (data) and spreadsheet software (Calc), and if the poster thinks that calling it “your” is OK when addressing to other users that help each other on the site.
Yes, I meant :spreadsheet programs." I called it “your” because I thought I was addressing the question to the people who wrote the program.
Two possible reasons might be here:
- You have
Show Formulaview mode active (see it in menuView); - Your cell is formatted as text (see
Format→Cells). In this case, whatever you input into the cell, is treated as textual string, not a number or a formula, regardless if it can be interpreted as such. Choose a numeric format to resolve this case.
Also user has wrong function:
LEFT
Returns the first character or characters of a text.
LEN
Returns the length of a string including spaces.
From the Help file.
It turns out I had “Show Formula” mode active. Thanks for the help!