Using R, I created a spreadsheet containing Arabic words (see here for more information regarding the spreadsheet creation). Each row contains one word, and the word character string has been split so that each column contains one letter. The first letter of each word begins on the right-hand side, and splits left. In the picture below, I have drawn a red oval around the first letter in each word for non-Arabic readers to see.
The dataframe is correctly formatted in R (see picture link below, top section). I exported it using readr::write_excel_csv and TextEdit displays the same data as what I see in R (see picture, middle section). The problem is that when I open up the datafile in Excel, the column values are inverted (see picture, bottom section): the LAST letter in each word appears on the right-hand side, and splits left. Please click here for the picture
For reprex purposes, please click here to access the .csv and .txt files I mentioned above.
How can I import the file in Excel so that it correctly imports without changing the order of the column values? Thank you in advance for your help!
与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
