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
Question marked as
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