Question : extract the second word in a text in excel
Answered by : kwams-ahortor
Excel formular
=LEFT(RIGHT(A1,(LEN(A1)-FIND(" ",A1))),FIND(" ",A1))
'Replace A1 with the desire cell.
Source : | Last Update : Tue, 21 Sep 21
Answered by : kwams-ahortor
Excel formular
=LEFT(RIGHT(A1,(LEN(A1)-FIND(" ",A1))),FIND(" ",A1))
'Replace A1 with the desire cell.
Source : | Last Update : Tue, 21 Sep 21