I am trying to use the Kharosthi script in Google Sheets, which is Right-to-Left. In Google Sheets, the script shows up properly while in cell-edit mode, but once it is confirmed it goes back to Left-to-Right.
1 Answers
go to File > Spreadsheet settings and change locale to RTL language
last option would be to use formula or script to reverse the string
function REVERSE(string) {
if (typeof string != 'string') {
return null;
}
return string.split('').reverse().join('');
}
=REVERSE(A1)
or without script:
=JOIN(, INDEX(MID(A2, LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))+1, 1)))
Related