Created attachment 177849 [details] Test sheet demonstrating wrong behavior of CALC RIGHT() function. I received a spreadsheet from a colleague in which Column A contained both the first and last names of individuals. I needed to separate them into FirstName and LastName columns. In order to separate them, I entered the formulas LEFT(A#,FIND(" ",A#)) and RIGHT(A#,(FIND(" ",A#)-1)) where # is the actual row number. The LEFT() function always works as expected. Not so with RIGHT() function. See the attached test sheet, especially rows 12-16. This behavior also exists in Apache OpenOffice 4.6/4.10 and I found it on three different computers using either Windows 7 or Linux Mint 20.1/20.2. AOO and LO are NOT simultaneously installed on any of these computers. The computers are a mixture of DELL Latitude E6510 laptops and Optiplex 9010 desktops.
I don't have earlier versions of LO or AOO available to test with.
You are misunderstanding how RIGHT() works, please take a look to the help. https://help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html?DbPAR=CALC#bm_id3149805 You can do it using right: =RIGHT(A12;LEN(A12)-(FIND(" ";A12))) or in your way with mid: =MID(A12;FIND(" ";A12)+1;99) Please in the future better find help in https://ask.libreoffice.org/c/english/5