Dear Excel Experts,
I am trying to sort an excel-spread sheet by the last letter of each word and am encountering some difficulty. Column A is filled with words which I want sorted. According to this link (google “how to alphabetize in excel last letter”, it’s the first hit on extendoffice) I have placed “=RIGHT(A1,1)” in B1 and subsequently dragged the ‘Fill Handle’ down to the last word in the A column.
Then I click on the ’Sort’ button with the intent to select ‘Sort A to Z’. Regretfully all the options in the ‘Sort Button’ are greyed out. If I try to press ‘enter’ on my keyboard I get the following error message:
“The formula you typed contains an error.
• To get assistance in entering a function, click OK, then click Function on the Insert menu.
• If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (‘).”
Any ideas what I’m doing wrong? Many thanks for your time and expertise.
Peter
Bookmarks