In general, we search word from left side in a string, but would you ever tried to reverse search the word in a string, which means to quickly get the last word from string as below screenshot shown. Here, I introduce some formulas to help you quickly find the last word in a string in Excel sheet.
Reverse search to find last word in Excel
Quickly Convert Multiple XLSX. Files To XLS Or PDF. Files In Once Time
|In many cases, you may want to convert between XLSX and XLS, or convert a workbook to PDF file, but in Excel, you only can convert one workbook once time, have you ever imaged to convert multiple workbooks at once time? With Kutools for Excel's File Format Converter, you can quickly convert multiple workbook to pdf/97-2003 workbook/2007 or higher workbook at once and save them in a folder, at the same time, a converted report is generated! Click for 60 days free trial!|
=RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
=IF(ISERROR(FIND(" ",A1)),A1, RIGHT(A1,LEN(A1) - FIND("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))))
Select a blank cell which you will place the search word, use one formula above, and press Enter key. Now the last words of the strings will be found.