Excel functions LEFT, RIGHT not working on mac os

Excel for Mac:

Extracting last or first word in a text string works on PC:

=RIGHT(A2,(FIND(" ",A2)-1))

but not in excel for mac.

ideas?

MacBook Pro 13″, macOS 13.6

Posted on Oct 16, 2023 3:20 PM

Similar questions

External Number Pad not work with Excel on Mac I have a Sunreed number pad that seems to work on everything (0123456789) here. But not on Excel. Using Mac Air and Perixx keyboard with no number pad. The ROW of numbers does work on excel - Just not the external keypad. HELP
1605 6
Redo not available in Numbers for Mac Hi I am putting together a spreadsheet in numbers and trying to add more rows but the redo option in the edit menu is greyed out and the short-cuts don't work either. This is pretty terrible as having to add rows manually is such a pain that I'm very tempted to use Excel. Does anyone know why this is not working?
1388 3
numbers won't export to excel Using MacAir, M2 2022. Monterey 12.5. Exporting Numbers to Excel does not work any longer. (Previously worked OK...now no longer working.) File>Export to>Excel produces a very small Excel file in the target directory. (220kB Numbers exports as a 12kB Excel) The small Excel file is not able to be opened by Excel, receive the following error message: Sorry, we couldn't find /Users/stevemarsh/Library/Mobile Documents/com~apple~CloudDocs/Documents/FAC/231030 FAC comments on 23:231030 FAC comments on 23:24 Reserve Study.xlsx. Is it possible it was moved, renamed or deleted?
1547 2

1 reply

John Galt

Level 10

155,090 points

Oct 17, 2023 12:06 PM in response to kpzola2

You would be much better off asking Microsoft, or posting your question in a Microsoft user community forum.

Contact a third-party vendor - Apple Support

Apple Support Communities may not be the worst place to find support for Microsoft products, but it's close. Try https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Excel functions LEFT, RIGHT not working on mac os

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up